Count occurrences in a drop down
Can anyone tell me why this statement isn't working? Thank you!
Best Answer
-
I think you are trying to count the amount of times Monday is in the Days on Campus column. If that's the case, Try this:
=COUNTIF([Days on campus]@row, CONTAINS("Mon"))
I see a lot of people use HAS vs CONTAINS but I just have better luck with CONTAINS. I'm sure someone smarter than me could explain why lol.
If might need the field to search within inside the CONAINS Statement so if that doesn't work try this:
=COUNTIF([Days on campus]@row, CONTAINS("Mon", @cell))
Hope this helps!
Answers
-
I think you are trying to count the amount of times Monday is in the Days on Campus column. If that's the case, Try this:
=COUNTIF([Days on campus]@row, CONTAINS("Mon"))
I see a lot of people use HAS vs CONTAINS but I just have better luck with CONTAINS. I'm sure someone smarter than me could explain why lol.
If might need the field to search within inside the CONAINS Statement so if that doesn't work try this:
=COUNTIF([Days on campus]@row, CONTAINS("Mon", @cell))
Hope this helps!
-
Thank you! That second one worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!