CountIFS Multi-Select Criteria
Smartsheet Community:
My Change Type Column Allows Multiple Values. Therefore, my Formula is Looking to See if it Has Scope or Time. If it does, then it Should Count. I Think The HAS Part of My Formula is Out of Place.
Current Formula:
=COUNTIFS(Project:Project, "OPAL", [Change Type]:[Change Type], HAS(@cell, "Scope")), [Change Type]:[Change Type], HAS(@cell, "Time"))
Thanks
Best Answer
-
It's because I can't type - Try this hopefully no typos
=COUNTIFS(Project:Project,"opal",[Change Type]:[Change Type],OR(Has(@cell,"Scope),Has(@cell,"time"))
Answers
-
Hello,
The HAS() should be like this:
HAS("scope", @cell)
and you have an extra ")" after the first HAS
The below should work, let me know!
=COUNTIFS(Project:Project, "OPAL", [Change Type]:[Change Type], HAS("Scope",@cell)
), [Change Type]:[Change Type], HAS("Time",@cell)) -
You are missing the OR formula.
=COUNTIFS(Project:Project,"opal,[Change Type]:[Change Type],OR(Has@cell,"Scope),Has(@cell,"time"))
-
Both Formula UNPARSEABLE
-
It's because I can't type - Try this hopefully no typos
=COUNTIFS(Project:Project,"opal",[Change Type]:[Change Type],OR(Has(@cell,"Scope),Has(@cell,"time"))
-
That Worked, Thanks! You were Missing a Quotation on Scope
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!