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