Formula for IF cell is NOT BLANK and value < 'x"

Simon Potton

Hi,

Looking for some help from the formula guru's out there.

Trying to write a formula for is a cell is not blank, and then value of the cell is less than 'x'.

I have the cell < 'x' already sorted, just trying to work out how to add the IF NOT BLANK part of the formula in as well.

Any help appreciated.

Thanks,

hollyconradsmith

Hi @Simon Potton,

NOT(ISBLANK(column@row)) is how you check if something is not blank.

You could use AND to combine both.

IF(AND(NOT(ISBLANK(column@row)), column@row<'x'), valueiftrue, valueiffalse)

https://help.smartsheet.com/function/isblank

hollyconradsmith

Hi @Simon Potton,

NOT(ISBLANK(column@row)) is how you check if something is not blank.

You could use AND to combine both.

IF(AND(NOT(ISBLANK(column@row)), column@row<'x'), valueiftrue, valueiffalse)

https://help.smartsheet.com/function/isblank

Simon Potton

Hi @hollyconradsmith

Thank you for getting back to me on my query!

I tried your suggestion, but the syntax was still not quite right. I found a work around with a BETWEEN formula that I tried, which has produced the right result.

Thanks for your help, my first time posting on the Smartsheet community forum and I'll definetely be using it in the future!

Thanks,

Simon