Formula Question
Given this example above, and with multiple choices available, what would be the formula to count the number of times Apples appear in the "Choices" Column? Thank you!
Best Answer
-
= COUNTIF (Choices:Choices, HAS(@cell,"Apples") )
Answers
-
= COUNTIF (Choices:Choices, HAS(@cell,"Apples") )
-
Thank you, @Brian_Richardson! worked like a charm! Much appreciated.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 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!