Forum Discussion

webbj's avatar
webbj
Helper I
4 years ago
Solved

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_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    Create a custom column named targetHit and put following formula there

    = [closedDate]<=[targetDate]