Formula for IF cell is NOT BLANK and value < 'x"
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,
Best Answer
-
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)
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
Answers
-
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)
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!