Fix TODAY formula

Julie Barbeau

Hello, 

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.

Andrée Starå

Hi @Julie Barbeau,

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

I hope that helps!

Have a fantastic Day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD