How can you capture the date stamp of a status change?

Sammy Eastwood

I am trying to capture the date stamp for when a row changes from one status to another. Is there any workaround to get this information, for example from using an integration to another software or through a report? I know you can look at an individual cell's history, but I will need to do this for hundreds of rows, so that is not sustainable. Capturing this data is vital to my team using Smartsheet.

Andrée Starå

Hi @Sammy Eastwood

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

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

Andrée Starå

Hi @Sammy Eastwood

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

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

Sammy Eastwood

Andree,

Yes that should work! Thank you so much!

For the VLOOKUP portion, how do I make the VLOOKUP table the entire column in the copy sheet so that it will dynamically update as more rows are copied over?

Thanks again!

Andrée Starå

@Sammy Eastwood

Excellent!

Happy to help!

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.

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

Mike Wilday

You can now set a date stamp based on another cell change using an automation workflow!

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.79950226.443393604.1609776795-1074882870.1602114816

summetg

https://community.smartsheet.com/discussion/comment/273954#Comment_273954

Hi all - so I just tried this and it doesn't seem to work when I have a the health status color change on our project rollup sheet. These health statuses are referenced from the project objects.

I tried "When Project Health changes to Any Value" to this. It did not work. The column project health is a referenced column which links via SCC at creation. However, I can trigger an email notification if the column values changed. Any ideas?

Mike Wilday

You might need to set that up as separate conditions... If it changes to red, if it changes to blue, if it changes to green, all with the same action. I have had issues where sometimes it was reading as it had to be all of those things. You also should test with a separate account, as sometimes I have had issues where the automation wasn't triggered by my own account in testing for various reasons.

Mike Wilday

Actually... you also have to save the sheet. Did you save the sheet before checking to see if a date is populated?

Mike Wilday

I had the following settings and found it took a second or two, but this worked for me. See my video below.

https://www.screencast.com/users/UC-Elearning/folders/Default/media/acbca233-710e-4f08-9b4a-1f9defe328a1