Date conditions

Jennifer Flanagan

Is there a formula to that would put mark the date when another cell changes?

So I want the "Actual End" cell to have the date when an invitation was "Approved" or "Declined."

David Joyeuse

Hi Jennifer,

I would suggest to use an automated cell "date modified" for this.

But this only works if there's no other modifications on this row after this. Otherwise the cell will update each time.

Andrée Starå

Hi @Jennifer Flanagan

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!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!