Monday currently allows you to record today’s date on a status change - for example, if Status is marked Complete we can record Completion Date.
We need to record NOW when status changes - time to the minute or second. How can we do this?
1 Like
I think you can make a custom automation that does this.
When Status is set to Complete
Then set DATE COLUMN to today.
When you select the Date Column, there’s a checkbox in the bottom left to Include Time.
We have one set up that logs request submissions like this.
Chris, as far as I can tell, that records the date with no time - TODAY, not NOW.
How did you get it to save NOW?
By default, it’s without time. But there’s a sneaky little checkbox called “Include Time” that does what you want.
When you’re creating the automation and selecting which Date column to populate, that little popup window has the checkbox. I’ll attach an image - worth a thousand words
.
2 Likes
Thanks.
UI is horrible! That check box is actually scrolled out of sight for me because I have multiple date columns!
1 Like
Oh, wow… I hate popup boxes in UI. The sizing always seems to fail. Glad this helped!
I never noticed this either
you can add a column “hour”, and set automation “when xxx status changes to xxx, set HOUR to current time”.
i think this is a new feature they just added.
I’m not sure if something has changed, but I’m working on this now and its not acting as described. Any other solutions?
Hi everyone! 
@mfriedma @RENEE.L @Kristinemd13 @johngcolejr @chbroussard
I suggest you to try Time in Status app which track time the Item has spent in each workflow status. So you can monitor how fast the Item moves between statuses in
Time format
The Format option lets you select the time format how the status duration will be displayed:
- DHM (Days, Hours, Minutes),
- HM (Hours, Minutes),
- h:m (hours: minutes),
- M (Minutes),
- Decimal Hours,
- Decimal Days,
- Decimal Weeks,
- Business DHM,
- Business Decimal Days,
- Business Decimal Weeks.
The app is also available in the format of board integration.
You can try it on the Monday Marketplace and share your experience with us.
Hope you find this app helpful.