Sheet Formulas Not Auto Updating

MFuller
MFuller ✭✭
edited 12/09/19 in Formulas and Functions

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!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!