Unfortunately, I still run into the problem that when I copy a row and insert it, the row below it will not update automatically. I think I need some kind of formula that is self referential without breaking, which is why I was considering OFFSET.