Capture Timestamps Before They Change

SYSPK

Is there a way to save a date that something occurs? We have rows that get changed constantly, and the status balls change from Green to Red to Yellow to Gray. Any way we can capture the date that a row's status ball changes to Red, even if it later changes to other colors?

Thank you!

Andrée Starå

Hi,

You could check the cell history or the activity log to see when the changes happened.

Depending on your needs something could be set up with the help of Zapier or similar service, but the easiest solution would be to look at the functions already included in Smartsheet.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SYSPK

Thanks for your quick response.

I did look through the available formulas and couldn't find anything. Maybe an integration app would help.

Andrée Starå

Did you also check the cell history and activity log features?

More info here: https://help.smartsheet.com/articles/518314-viewing-cell-history

Would that work?

Best,

Andrée

SYSPK

No, we need the dates to show in the cells so we can use that for more formulas and reports.

Andrée Starå

Ok.

Then it's Zapier or a similar service that you need to use.

Have a fantastic weekend!

Best,

Andrée

neelesh

Hi,

Just wanted to know if there has been any solution from Smartsheet on the Time stamping for a specific cell change. 

 

Thanks