IS Before Catching Errors

[Jason_Hawkes]

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…

[Elias_Gomez_Sai]

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.