Automating Start Date

PatK

Hello,

In my sheet I have a "Start Date" column that I would like to automate. In a separate status column I have a drop down option that includes, "Not-Started", "In Progress", "Completed". Once the status column is switched to "In Progress" I would like the Start Date column to automatically post the current date. Once that date is posted I would like to use that initial date indefinitely, unless the status column is switched back to "Not-Started".

Does anyone have ideas for a possible formula or other solution for this?

Thanks!

Andrée Starå

Hi @PatK

I hope you're well and safe!

You can use a workflow combined with the record a date action to register the date when the status column changes.

Would that work/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @PatK

I hope you're well and safe!

You can use a workflow combined with the record a date action to register the date when the status column changes.

Would that work/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PatK

Thank you Andrée!

That works great.

Andrée Starå

@PatK

Excellent!

Happy to help!

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