Capture date when row changes

KyleAnderson

Hi,

 

I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed.

 

ie:

1. When status column changes to "animating" - start date needs to capture the date(fixed value) it was changed to "animating"

2. When status column changes to "approved" - end date needs to capture the date(fixed value) it was changed to "approved"

 

Can this be done with automated workflows or with a Smartsheet formula.

 

Thanks,

Kyle

 

Andrée Starå

Hi Kyle,

Unfortunately, it's not possible at the moment to capture and store the date, but it's a great idea! 

Please submit an Enhancement Request when you have a moment.

As a workaround, you could use the third-party integration, Zapier. It's excellent for this use case.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD