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?



Best Answer

  • Pamb10
    Pamb10 ✭✭✭✭
    Answer ✓

    Thanks sooo much for all who took a stab at this one....

    I had an epiphany over the weekend, so I gave this one thing a try.

    I copied the formula to the top row, ie. where the month name is. It was like this for the # Days column, so i did the same for Monthnumber. That seemed to perform the magic I needed.

    Thanks again to all.