Recording dates in single workflow

Kaveri Vipat

Hello Everyone,

I hope you are doing great

I am trying to record 4 different dates in a single workflow but getting dates in only in the 1st date column and all the 3 date columns are not working.

In my sheet I have 4 different status columns and their value is (Not Started, In Progress and Complete)

Status 1 - Not Started, In Progress, and Complete

Status 2 - Not Started, In Progress, and Complete

Status 3 - Not Started, In Progress, and Complete

Status 4 - Not Started, In Progress, and Complete

Now, I want to record dates of Status when it changes to Not Started, In Progress, and Complete

If status 1 changes to Not Started then the date should be recorded in the Record date "Not Started" Column same for if it is changed to In Progress the date should be recorded for the Record date "In Progress" column. and same for all the status.

All I want is to create a single workflow for Not Started status (for all the 4 columns), In progress, and Complete. I don't want to create 12 workflows for this.

Please guide me to achieve this, I hope my requirement is clear.

Thanks in advance!!

Andrée Starå

Hi @Kaveri Vipat

I hope you're well and safe!

You'd use the Condition Path feature for this.

More info.

https://help.smartsheet.com/articles/2479251-condition-blocks-filter-what-your-automated-workflows-send#toc-what-to-expect-with-overlapping-condition-paths

Did 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!

Gia Thinh

Hi @Kaveri Vipat,

Below are screenshots of 3 workflows for Not Started, In Progress, Complete.

Hope that helps

Kaveri Vipat

Hi @Andrée Starå,

Yes, I am good

Yes I use the conditional path feature but getting dates in the 1st Status dates not for 2nd,3rd and 4th.

Thanks

Tabitha79

Does this workflow work with drop down list columns? When I try to set this workflow up off a drop down list column, it does not give me the option to choose an item from the list as a condition. I need the date to record when the status is changed to "Construction", it just shows "changes" and does not give me the option of "change to".

SS Dropdown.docx