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?
Help Article Resources
Check out the Formula Handbook template!