Status Column Change to Record Date of Change



I am developing metrics for a group at my company and need some help. They do not log when they mark something as complete by date just by status. The date of the status change is in the cell history but I was wondering if there was a way to write a formula to show when a status is set to completed it records the date in a separate column. Does anyone have any experience with a formula like this? I am not sure where to start.

Thank you!


Best Answer

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    Answer ✓

    Hi @tim.curtin

    The "Record a Date" feature is found within the Automation tab. First add a date column to your sheet and then go "Create Workflow from Template", scroll to the bottom and choose "Record the date when specificed criteria are met". It will explain what it does. From there the options are pretty straight forward. Let me know if you have any questions.



    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!