Sheet Formulas Not Auto Updating
Just recently I noticed that the formulas within my sheet are not working in the background and updating my reports as they used to. I have a formula that populates a status based on a date, so if the date is in the past, it marks the status complete and then my report only pulls tasks that are not complete - I only have this formula in one of the 12 parent sheets of my report. BUT, the last week this formula isn't automatically working so there are past dates activities in my "today" report. When I open the sheet that should be automatically updating, it runs all the formulas which updates fields and then suggests I save the changes (without me actually touching anything) and then my report is correct. Is anyone noticing the same issue and/or is there something that changed in the back end that I need to work around. Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!