Skip to main content
Question

Days open unless Status = Closed, then stop.

  • November 20, 2017
  • 0 replies
  • 55 views
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.
    This topic has been closed for replies.

    Forum|alt.badge.img+5
    • DrewVoge
    • Registered
    • November 22, 2017
    this is the formula from one of my apps for the exact same purpose.  

    If([Status]="Closed",[Date - Closed]-[Date - Opened],Today()-[Date - Opened])
      Mike,
      Do you have a field for [Date Closed] or does that also need to be captured when the Status changes to Closed.
      Terms & ConditionsAccessibility statement