COUNTIFS multi drop down list and check box
I have a sheet where I am counting the number of variance root causes if the milestone field is checked (first column). Variance root cause is a multi select drop down. In the above example, the count would equal 4 (I would not count the root cause for task 3 since milestone is not checked.
I have the formula working with multiple COUNTIFS added together but think there must be a cleaner/better way to do it.
=COUNTIFS({Root Cause}, CONTAINS("Build Challenges", @cell), {Milestone}, 1) + second equation, etc…
Any thoughts or hints would be appreciated.
Thank you!
Answers
-
Hello SteveE,
I like those snippets. Pretty neat!
This is what I would try aside from demarcating each individual drop-down possibility, a look-up table would be able to do this same thing. Personally, I prefer the formula because it is cleaner and if isnt broke… why fix it?
Hope this helps!
Respectfully,
CEO | Skyway Consulting Co.
Does your Dashboard need a map that updates from Smartsheet Data?
We pioneered 101+ ways to add a map to a Smartsheet Dashboard.
Smartsheet and GIS Integrations
→ Explore Smartsheet Maps (ArcGIS)
→ LinkedIn
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!