Formula to count days in current status.

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
------------------------------