Help with a formula: Do not run formula if cell is blank
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.
Help Article Resources
Check out the Formula Handbook template!