Exclude blank rows from intra-sheets IF formula
Hello,
I am very new to Smartsheet and figuring out how formulas work.
I am using this formula to have a checkbox column checked when the values of another column match the ones of another sheet. I realized that in this other sheet that I am comparing it I have blank rows and when this happens the checkbox column is checked. How can I avoid this i.e. add to my formula to not check when there are blank rows?
My formula:
=IF(COUNTIFS({BioDISC test Range 3}, Species@row) > 0, 1, 0)
Thank you!
Silvia
Answers
-
Hi @Silvia Brochet,
You can use the ISBLANK() function to help you filter out blank cells:
=IF(AND(NOT(ISBLANK({Cell Range})), COUNTIFS({BioDISC test Range 3}, Species@row) > 0), 1, 0)
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!