Formula to Automate Dates

Krista Cornew

Hi!

I am looking for a formula for my "Actual End" Column that will auto-fill the date when the "Assigned To" statues a task as "Complete.

Can anyone help with this?

Krista

Paul Newcome

Have you looked into the Record A Date Automation yet?

Andrée Starå

Hi @Krista Cornew

I hope you're well and safe!

To add to Paul's excellent advice/answer.

More info.

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action

I hope that helps!

Be safe and have a fantastic weekend!

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!

Krista Cornew

@Paul Newcome and @Andrée Starå Thank you!!

Paul Newcome

Happy to help. 👍️

Andrée Starå

@Krista Cornew

Excellent!

You're more than welcome!

✅Remember! 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!