Date Formulas Do Not Auto Update?


I have several sheets with formulas calculating the difference between a given date and the current date. This formula only updates upon opening the sheet and then saving.

I have about 25 sheets, this means for the calculation to update daily, I need to open each of the 25 sheets to update each of their formulas. Is there a way to automate this process within SmartSheet? It is quite cumbersome having to do this every single day.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!