Forum Discussion

MikeBlinkhorn1's avatar
MikeBlinkhorn1
Qrew Trainee
8 years ago

Days open unless Status = Closed, then stop.

I need a days open field to count up, UNLESS another field (Status) is equal to closed. If Status is is equal to closed, the days open should stop at the number of days between creation and the date the Status was marked closed.
Formulas and functions
  • DrewVoge's avatar
    DrewVoge
    Qrew Cadet
    8 years ago
    this is the formula from one of my apps for the exact same purpose.  

    If([Status]="Closed",[Date - Closed]-[Date - Opened],Today()-[Date - Opened])
    • AllisonLewey's avatar
      AllisonLewey
      Qrew Member
      5 years ago

      Suggestions for how to tailor this to also factor in only the amount of week days open? 
      This formula worked perfectly for my days open indicative of an item not being closed, but I foresee the team wanting it to reflect only the number of business days open. 

      Thank you,
      Allison

      ​

      ------------------------------
      Allison Lewey
      ------------------------------
      • AustinK's avatar
        AustinK
        Qrew Commander
        5 years ago
        WeekdaySub(Today()-[Date - Opened]) I think changing the end of the formula to this would do it. You may have to reverse it and have date - opened first.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Mike,
    Do you have a field for [Date Closed] or does that also need to be captured when the Status changes to Closed.
    • DrewVoge's avatar
      DrewVoge
      Qrew Cadet
      8 years ago
      Good point.  I should have pointed out that the field [date - closed] is populated by form rule when the record is saved and the value of [status] has changed to "closed".