Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Suppress Date errors if date field is blank

Topic Labels: Formulas
986 1
Showing results for 
Search instead for 
Did you mean: 

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()),“ :triangular_flag_on_post: Past Due”,“ :heavy_check_mark: On Track”))

1 Reply 1

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