Formula for Modified Date
I want to keep track of End Date changes on workstream plans. Aware the automated Modified Date column is updated following any change to that row. I want to find a way to populate a Changes Log with specific information from a row, if the End Date Column has been updated. Unfortunately, the layout of the activity Log is too detailed for the type of view we're trying to present.
It would be great if there was a formula I could use to insert Todays Date into a hidden Column whenever the End Date Column has been updated. That way I know when the End Date was updated and not the entire row.
I tried inserting a Variance column (End Date - Baseline Date). Although if the End Date is changed a second or third time (which is possible), it won't pull through in either the Zap or Smartsheet Report.
Thanks again for your help,
Help Article Resources
Check out the Formula Handbook template!