Forum Discussion

TannerPruitt's avatar
TannerPruitt
Qrew Member
5 years ago

Formula to count days in current status.

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
------------------------------
Formulas and functions
Quickbase Automations
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------