Formula to count days in current status.

Question

I am wanting to track the # of days in the current status and hoping to add a formula field that will perform this. For example, if a project is on hold for 20 days and the status changes to materials ordered, the count goes back to 0. Any suggestions?

------------------------------
Tanner Pruitt
------------------------------

MarkShnierYou · Answer

I suggest making a child table of the History of the Status changes. have an Automation add a record to that table whenever the Status changes and write out a record with the Status and I suppose the [Last Modified by] of the Parent record.

Then just make a summary field of the [Date Created] on that Parent record so now you know the date of the most recent update.

Then the # Days in the Current Status will be

ToDays(Today() - ToDate([my summary field of last update]))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community