Red Flag If statement

edited 12/09/19 in Formulas and Functions

I have an if statement that is doing what I need except when there is no value in the deadline column. I want to keep the functionality I have but make sure the flag is not red when I have no deadline set.

=IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 1, 0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!