Date of column modification

jspark

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

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

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

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”.

Regards,

Michael