Skip to main content

I have a status field that reflects status based on a date field {Finish} being overdue. The status field returns #ERROR! if the Finish date field is null. Can somebody help me extend this formula to suppress displaying #ERROR! if no date value entered?


Here’s the start of the formula, which works if there is a value for {Finish}


IF({Complete}=BLANK(),IF(IS_BEFORE({Finish},TODAY()),“ 🚩 Past Due”,“ ✔ On Track”))

IF({Complete}=BLANK(),IF({Finish},IF(IS_BEFORE({Finish},TODAY()),“🚩 Past Due”,“✔ On Track”),"No Finish Date Set"))