Need column showing when status was changed

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!