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?
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?
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
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’)))`
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.