Setting a flag want to ignore blank cells

Options

I have this formula. It works well unless the cell is blank


=IF([Warranty End Date]@row <= TODAY(), 1, "")

How do I insert the ISBLANK logic in this formula? So far, It hasn't worked.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!