Help

Suppress Date errors if date field is blank

Topic Labels: Formulas
1286 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_McShane
4 - Data Explorer
4 - Data Explorer

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"))