Nate Montgomery @ SmartSuite
Merged in a post:
Expose the "Time in Status" or "Date Status Updated" natively through a field or formula
C
Caleb Cook
SmartSuite currently tracks when a status was updated to be able to calculate duration from the due date - can we expose the "datetime status updated" and/or "time in status" as a field or formula? Currently I'm just using an automation to log when a status changes, but it would be great to have this exposed natively.
Jon Darbyshire
Hey Caleb Cook, thanks for your feedback! I have a few more questions for you:
- Can you provide more details on how you envision the 'datetime status updated' and 'time in status' being displayed within the interface?
- Are there specific workflows or use cases where this feature would be particularly beneficial?
- Would you like this feature to be customizable or should it follow a standard format across all statuses?
C
Caleb Cook
Jon Darbyshire
- exactly like the "Last Updated" system field - with the option to change the display and format, the only difference is it only reflects the status changing.
- ability for a manager to see a Dashboard view of tasks that changed their status in the past day (or whatever custom timeframe)
- I could see one of the options being to select the field that you want to "track" if there are multiple Status fields... but other than that - standard format within the table of just showing the date that the status field was changed.
Brian Dollen
6 Stars Cleaning - This is currently possible using a collection of static date fields and our LAST_MODIFIED_TIME_STATUS() formula function. You can have a trigger of "When a status changes, set date field to formula value" and then have additional formulas that can calculate the time between any static date fields including First Created.
If you had a different implementation idea in mind, let us know!