Boolean Blank if cell is blank?

Options

I am trying to create a boolean formula in which if the cell is blank the formula does not apply.... below is the formula I currently have

=IF([Av3000 Due Date]@row <= TODAY(), "Red", IF([Sure Seal Due Date]@row <= TODAY(), "Red", IF([Half Face Due Date]@row <= TODAY(), "Red", IF([Weld O Vista Due Date]@row <= TODAY(), "Red", IF([Av3000 Due Date]@row <= TODAY(+30), "Yellow", IF([Sure Seal Due Date]@row <= TODAY(+30), "Yellow", IF([Half Face Due Date]@row <= TODAY(+30), "Yellow", IF([Weld O Vista Due Date]@row <= TODAY(+30), "Yellow", "Green"))))))))


The issue I'm having though with the above formula is that if there is nothing in the cell its turning my Boolean red.... Please Help!!!

Answers

  • Geard Ledet
    Options

    =IF(ISBLANK([Av3000 Due Date]@row), "Green", IF(ISBLANK([Sure Seal Due Date]@row), "Green", IF(ISBLANK([Half Face Due Date]@row), "Green", IF(ISBLANK([Weld O Vista Due Date]@row), "Green", IF([Av3000 Due Date]@row <= TODAY(), "Red", IF([Sure Seal Due Date]@row <= TODAY(), "Red", IF([Half Face Due Date]@row <= TODAY(), "Red", IF([Weld O Vista Due Date]@row <= TODAY(), "Red", IF([Av3000 Due Date]@row <= TODAY(+30), "Yellow", IF([Sure Seal Due Date]@row <= TODAY(+30), "Yellow", IF([Half Face Due Date]@row <= TODAY(+30), "Yellow", IF([Weld O Vista Due Date]@row <= TODAY(+30), "Yellow", "Green"))))))))))))


    IT was all in the ISBLANK function!! I figured it out!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!