Hi all - we have a Status column, featuring a status “Ready”.
Ideally, I would like to simply see a column that tallies how many business days it’s been since that status column was set to “Ready”.
Minimally, if I could have a column that simply reflects the time and day that the status was set to “Ready”, that would solve the issue I’m having.
Thanks in advance!
@lkennedybyrne
Add a date column and use this automation to set it to today when Status changes to “Ready”.
If you want a count, add a formula like this formula:
IF({Status}="Ready", DAYS(FORMAT_DATE(TODAY(), "YYYY-MM-DD"), {Date}), "")
** Edit
For workdays, use this:
IF({Status}="Ready", NETWORKDAYS({Date}, FORMAT_DATE(TODAY(), "YYYY-MM-DD")), "")
OR
IF({Status}="Ready", NETWORKDAYS({Date}, FORMAT_DATE(TODAY(), "YYYY-MM-DD")) - 1, "")
Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: A Status Column Tip - When is “Done” really DONE?
Contact me directly here: [Contact – The Monday Man](Contact – The Monday Man
Hi @lkennedybyrne !
Monday.com also released a new automation recipe block that says “increase/decrease a number by value”. You can find it in the custom automations!
Here is what yours would look like:
Hope this helps!