Last modified Based on status change

1525 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

This would’ve been great if we can keep the last modified date of when the status changed to a certain pre-defined value regardless of what other value is added after this.

For example if update a status from “Assigned” to “In-Progress” it will update the LMD, but if i Update it from “Assigned” to “Closed” it would do nothing?

3 Replies 3
6 - Interface Innovator
6 - Interface Innovator

I’m a little confused as to what you’re looking for exactly.

Do you want it to keep the history of every time the status was changed, or are you looking just to have the last modified time for everything other than “closed”?

Do you have any screenshots of your current table you’re working with?

SO if a status changes from “To Do” to “In-Progress” I could have a have a Column called Dev Start Date then when the Statis changes from “In-Progress” to “Code Review” I could have a Column call Dev complete date and i could track actual dev time based on these columns

You could do this in reverse:
Use date fields for each milestone, and make the {Status} field a formula using a series of IF() statements.

IF({Dev Start Date},‘In-Progress’,IF({Dev Complete Date},‘Code Review’,IF({Code Review Complete Date},‘Complete’,‘To Do’)))`