Forum Discussion
webbj
Helper I
4 years agoCalculating 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_Verma
Most Valuable Professional
Create a custom column named targetHit and put following formula there
= [closedDate]<=[targetDate]- webbj
Helper I
Many thanks!