IS Before Catching Errors


#1

I have written the following formula to identify when a SLA is missed or MET based on the Date Completed and the SLA DUE Date.

IF(IS_BEFORE({SLA Due},{Date Completed}),"SLA MISSED ",‘SLA MET’)

This works but it shows ERROR when the Date completed is blank.

How do I catch the error?

Jason…


#2

Ideas:

  • Nested IF to check if there is Date Completed
  • Use the AND function in the condition of the IF, so you check for both: Date Completed and IS_BEFORE.