Forum Discussion
webbj
4 years agoHelper I
Calculating whether ticket is closed within time
So the data pulled from our system returns the date raised, date completed and the target date.
Whats the best way either adding a column or via calculation so calculate whether or not the completion date is less than or equal to the target date.
Ticket number | submittedDate | closedDate | targetDate
xxxxx 12/12/2022 13/12/2022 15/12/2022
If closed date is less than or equal to targetdate then targetHit = true else targetHit = false
Create a custom column named targetHit and put following formula there
= [closedDate]<=[targetDate]
2 Replies
- Vijay_A_VermaMost Valuable Professional
Create a custom column named targetHit and put following formula there
= [closedDate]<=[targetDate]- webbjHelper I
Many thanks!