Capture date when row changes

Options

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

 

smartsheet.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!