Today Function - Updating Issues

I am having a heck of a time with the today function not updating. I have tried automations to record date, and automations to lock and unlock. They both seem to work intermittently, the lock and unlock intermittently won't unlock. The date recording seems to be recording the date fine, but the reports that get emailed out, still intermittently do not update. This has been extremely frustrating as it causes inaccuracies in data; honestly it makes me look pretty silly and inept.


Does anybody have any solutions that might help me, or perhaps workarounds to completely replace the today function entirely.


I appreciate your time and your assistance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!