Add new row, calculated field not updating
I have a sheet that uses Hierarchy (on month) and is displayed in descending sort order. I have one calculated field that should be automatically calculated when a new row is added.
When the person who will be entering data adds a new row, they are using "Insert Above" to add the row. The calculated field is not updated.
How can I force the calculation to happen automatically?