Date & Timestamp a specific cell change
I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold
When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be duplicated to two other columns I have 'Modified Date' and 'Completed Date'.
When the status in a cell changes to In Progress or On Hold, I would like the 'Modified Date' cell on that row to log the date and time.
When the status in a cell changes to Completed or Cancelled, I would like the 'Completed Date' cell on that row to log the date and time.
Could you offer step by step instruction or point me to a video that shows how to accomplish this, if possible.
Thank you so much for your help and sorry if I've explained poorly.
Help Article Resources
Check out the Formula Handbook template!