Date Tracking

I need to track dates based on the milestone change. But i'd like to keep this in a separate sheet, but also include other key columns in order to create report.


Sheet 1 contains all data, Customer, ID, Milestones (drop down menu: received, submitted, etc.)

Sheet 2 - need Customer, ID, and date that the milestone changes - this sheet contains columns that match the name of the milestones in sheet 1.

I know how to set the workflow to track a date into a column on the same sheet, but can I have it record a date instead in Sheet 2 and also copy the customer and ID as well?

thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!