Forum Discussion
6 Replies
Sort By
- DrewVogeQrew Cadetthis is the formula from one of my apps for the exact same purpose.
If([Status]="Closed",[Date - Closed]-[Date - Opened],Today()-[Date - Opened])- AllisonLeweyQrew Member
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
------------------------------- AustinKQrew CommanderWeekdaySub(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.
- QuickBaseCoachDQrew CaptainMike,
Do you have a field for [Date Closed] or does that also need to be captured when the Status changes to Closed.- DrewVogeQrew CadetGood 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".