Calculating whether ticket is closed within time

[webbj]

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

[Vijay_A_Verma · Accepted solution]

Create a custom column named targetHit and put following formula there

= [closedDate]<=[targetDate] 

[webbj]

Many thanks!