Question Using TODAY Formula
Good day, I have a basic question, is there a way to use the TODAY function in a formula that will run the calculation and update my sheet without having to open the sheet everyday to "trigger" the calculation?
What I am getting at is I have a sheet that uses TODAY in many calculations, however, due to the size of the sheet, my team almost always uses reports & Dynamic Views to manage their projects and we almost never open the primary data sheet. This obviously causes issues with date calculations when using the TODAY function in the a formula.
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!