Days open unless Status = Closed, then stop.

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered
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.
Photo of Mike Blink

Mike Blink

  • 130 Points 100 badge 2x thumb

Posted 2 years ago

  • 1
  • 2
Photo of Drew

Drew

  • 492 Points 250 badge 2x thumb
this is the formula from one of my apps for the exact same purpose.  

If([Status]="Closed",[Date - Closed]-[Date - Opened],Today()-[Date - Opened])
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Mike,
Do you have a field for [Date Closed] or does that also need to be captured when the Status changes to Closed.
Photo of Drew

Drew

  • 492 Points 250 badge 2x thumb
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".