Recording the Date when a Status changes in a column

Maha.

Hi,

I am looking to build reports on how long it took for a status to change into another status. I have read some of the previous solutions; record a date automation, but it seems like this isn't working for me.

When I am trying to create the automation it gives me only one option in the "record a date in" > "select a date column". I have created a new column with "date" value, but it doesn't seem to appear as an option.

Has anyone had this happen before?

Maha.

Edit: Found the solution

Andrée Starå

https://community.smartsheet.com/discussion/comment/450336#Comment_450336

Hi,

I hope you're well and safe!

Excellent! I'm glad you got it working!

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Please support the Community by marking your comment as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!