How to ensure top line formulas calulate when rows are added

Hi Everyone I am reaching out as unsure how to do this. I am using a smartsheet form to enter holidays for staff members. I want to ensure my parent summary calculations update when rows are added. At present the forumula I am using to calculate forecasted holidays are as follows....... but when rows are added it doesn't update. I have attached a copy of the sheet I am using

=SUMIFS([No of Days]4:[No of Days]5, [Leave Type]4:[Leave Type]5, OR(@cell = "Holiday", @cell = "Statutory Holiday"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!