Enter dates automatically from colums selection

Shahara Anderson

Hello,

I am trying to have dates enter automatically based on column selection. In the example below, then the column says yes, the dates are blank. When the column goes to"In Process," the date is recorded in Milling SD. When the column goes green or "Completed," the Milling ED is recorded.

Is this possible?

Thanks,

Shahara

Andrée Starå

Hi @Shahara Anderson

I hope you're well and safe!

Yes, you set up Workflows combined with the Record a date feature.

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

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 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 @Shahara Anderson

I hope you're well and safe!

Yes, you set up Workflows combined with the Record a date feature.

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

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Shahara Anderson

Hi @Andrée Starå,

I hope all is well on your end. Thank you so much; your solution is perfect. I didn't even think about a workflow! Have an amazing week.

Best,

Shahara

Andrée Starå

@Shahara Anderson

Excellent!

You're more than welcome!