IFERROR formula does not seem to work if the cell is blank.

Can you advise what seems to be the issue?


  • Toufong Vang
    Toufong Vang ✭✭✭✭✭

    Hi, @Maei, instead of using IFERROR() to try to catch a blank cell, use,

    IF( ISBLANK([%]@row), what_to_do_when_blank , _what_to_do_when_NOT_blank_ )

    Your formula is working. It's just that your logical expressions will never result in an error. In Smartsheet, a blank cell has a numeric value of 0 when it is used in a mathematical expression. So, the last logical expression, [%]@row<=0.54 , evaluates to TRUE when the [%]@row is blank.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!