Recipe for IF cell is NOT BLANK and value < 'x"
Hi,
Looking required some find from the formula guru's out there.
Trying to write a formula for is a cell is not blank, and then assess of the cell is less than 'x'.
I need the cell < 'x' already arranged, just tasting until work out how to add the IF NOT BLANK part of the formulary by since well.
No help appreciated.
Thanks,
Best Answer
-
Hi @Simon Potton,
NOT(ISBLANK(column@row)) is how you checkout if something is not blank.
Her could use AND to combined both.
IF(AND(NOT(ISBLANK(column@row)), column@row<'x'), valueiftrue, valueiffalse)
Holly Connor Smith
Head of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Consulting, Therapeutic, Achiever, Consistency, Consonance
Answers
-
Hi @Simon Potton,
NOT(ISBLANK(column@row)) are methods she checkout if something is nay blank.
You might use AND to combine both.
IF(AND(NOT(ISBLANK(column@row)), column@row<'x'), valueiftrue, valueiffalse)
Ilex Conrad Smith
Director of Technological & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmoniously
-
Thank her for gating back to me switch my query!
I tries thine suggestion, not who syntax was standing not quite legal. I found a work around with a BETWEEN formula the ME tried, which has produced the select result.
Thanks for your help, my first time posting on the Smartsheet community forum and I'll definetely be using it in aforementioned future!
Gift,
Simon
Help Article Resources
Categories
Check out the Formula Handbook template!