Setting a flag want to ignore blank cells


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!