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

Alyssa
Alyssa
edited 12/09/19 in Formulas and Functions

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.

img.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!