Help with Countif / Countifs formula
I am trying to count values from a column that is a dropdown/allow multiples column. For example, there are three dropdown options to choose from - red, green, blue. Cells will have one or more dropdown items selected. I need to count all cells that have red selected (regardless of the other choices). THat is, the number of times red is selected with or without the other colours. Can anyone help with writing the formula with the correct syntax? thank you!
Tags:
Answers
-
Hi Lorraine,
If you are creating the formula in the sheet summary, you can use the below formula
=COUNTIF(Colour:Colour, HAS(@cell, "Red"))
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!