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


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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!