Skip to main content

IS Before Catching Errors

  • November 8, 2018
  • 1 reply
  • 16 views
J

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…

    1 reply

    E
    Forum|alt.badge.img+17

    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.
    Terms & ConditionsAccessibility statement