Date of column modification

I would like to create a column (Status Modified) that will show the last day that another column (Status) on the same row was modified.

What formula can I use to get this information on my Status Modified column?



  • bbates
    bbates ✭✭

    SmartSheet has a column type called "Modified" which updates the row modification date/time upon save. Although this won't be specific to the Status column being updated but rather any updates to the row. You can use the both formula to determine the weekday of any date:

    =IFERROR(IF(WEEKDAY(Modified@row) = 1, "Sunday", IF(WEEKDAY(Modified@row) = 2, "Monday", IF(WEEKDAY(Modified@row) = 3, "Tuesday", IF(WEEKDAY(Modified@row) = 4, "Wednesday", IF(WEEKDAY(Modified@row) = 5, "Thursday", IF(WEEKDAY(Modified@row) = 6, "Friday", IF(WEEKDAY(Modified@row) = 7, "Saturday"))))))), "")

  • SteyJ
    SteyJ ✭✭✭✭✭✭

    It looks like a job for automation.

    Go to automation tab -> when a row is changed, & when Status changes to any value -> record a date in the Status Modified column


    Jacob Stey

  • Alpha Chucky
    Alpha Chucky ✭✭✭✭

    Hi jspark! I don't think this is a simple formula fix. Give this a go and see if it helps:

    Automation Workaround:

    You might be able to use an automated workaround to somewhat achieve this by using Smartsheet’s automation and workflow features:

    1. Add the "Modified" date column from the Create column drop down.
    2. Create a New Column: Name it something like "Status Modified" and define it as a DATE column type
    3. Create an Automation Rule:
      • Trigger: When "Modified" is changed.
      • Actions: Insert the current date into "Status Modified".

    Here’s a step-by-step:

    • Navigate to "Automation" > "Create a Workflow".
    • Create a new rule. Name it descriptively.
      • Set up the trigger, e.g., "When rows are changed".Add criteria: “When ‘Modified’ column changes”.
    • Add an action:- Record a date - “Modify the ‘Status Modified’ to the current date”.



    Projects Delivered. Data Defended.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!