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 t...
Forum Discussion
Mike,
Do you have a field for [Date Closed] or does that also need to be captured when the Status changes to Closed.
Do you have a field for [Date Closed] or does that also need to be captured when the Status changes to Closed.
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".