Help with a formula: Do not run formula if cell is blank

Alyssa

Rookie here -- I'm hoping to get some help with a formula issue. I am trying to flag the "Attn" column if "Days Until Due" is less than 120. However,  I don't want the "Attn" column to flag if the cell is blank.

I currently have this formula configured for the Attn column, which has the flag symbol:

=IF([Days Until Due]1 < 120, 1, 0)

Looking for the correct formula to not flag if running against a blank cell.

Thanks in advance.

L_123

=IF([Days Until Due]@row < 120, IF(ISBLANK([Days Until Due]@row), 0, 1))

Alyssa

This worked perfectly!! Thank you, Luke! 

 

 

L_123

Not a problem. If you have a drag down formula the @row reference is faster for smartsheet to process. You could also use an AND function here with the same results.