Track Task Status Change Dates with a Custom Field and Automation
Featured
A manager recently asked if we could track the date a task's status was last updated. While Wrike’s default “Last Modified Date” captures any change to a task, it doesn’t isolate status changes.
To solve this, I used a Custom Field and Dynamic Dates Management in Automation. Here’s how:
1) Create a Custom Field
Name it something like Status Last Updated Date. Set the type to Date.
2) Set Up Automation
-Apply rules to: Tasks
-Trigger: When status changes to any (Active, Complete, Deferred, Cancelled)
-Action: Change custom field → select your new field → set value to the formula Today()
Now, whenever a task’s status changes, the custom field automatically updates with the current date.
Hope this helps others looking for a similar solution!
Hi David Simmington,
thank you for sharing this use case, very smart solution!
Florian
This is a great tip. We have a team doing this and they took it a step further with formulas. They created custom fields to track the number of days between specific status changes. Eventually we'll use that data in a Tableau dashboard for deep reporting.
Well done David Simmington