Can SmartSheet Count & Return all other values besides "X"
Hello Everyone,
I have a metrics sheet that is counting specific text ("Alpha") from a source sheet with the following formula:
=COUNTIFS({Supplier}, Description@row, {Status}, "On Order") **This works**
Ideally, I would like to count all the non-blank cells that do not have "Alpha" inputted. Can this be accomplished?
Thank you in advance for the help,
~ Drew
Answers
-
Hey @Drew Frazelle
=COUNTIFS({Supplier}, Description@row, {Status}, <>"On Order")
Will this work for you?
Kelly
-
Kelly,
Thank you. This formula works if the Description@row matches the inputted value in the {Supplier} reference sheet. Problem is, I want to count all the other "On Order" rows that are not "Alpha" if that is possible. Perhaps utilizing NOT or CONTAINS to exclude the "Alpha" orders. Sorry for the confusion.
Thanks again,
~ Drew
-
Hey @Drew Frazelle
Sorry, to clarify, the Alpha is found in what column? The Supplier? Or is it in place of "On Order"? In addition to "On Order"? If it is in addition to On Order is this column a multi select column (you can have both On Order AND Alpha within the SAME cell?)
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!