Fix TODAY formula


I am looking for a way to have the current date in a formula when a condition is met BUT that this date does not change afterwards, that is to say that it remains fixed and not that it is updated. The goal is to know on which date a task was completed.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!