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

Maei

Can you advise what seems to be the issue?

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.