Discussions

Expand all | Collapse all

Formula to count days in current status.

  • 1.  Formula to count days in current status.

    Posted 15 days ago
    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
    ------------------------------


  • 2.  RE: Formula to count days in current status.

    Posted 15 days 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
    ------------------------------