Formula with multi select and two fields
I am trying to create a report that shows me June comms, broken out between wireless and wireline, counting how many times the categories occur. I know it's a combo of countifs and contains I just can not figure out the order.. I have tried the following formulas:
=COUNTIFS({Month Column},$[Primary Column]76, {Segment Impact}, CONTAINS([Column2]$75@cell)
=COUNTIFS({Month Column},$[Primary Column]$76,{Segment Type},$[Primary Column]$77 {Segment Impact}, CONTAINS($[Column2]$75@cell))
Answers
-
It looks like you are just missing a couple of commas. You need one after $[Primary Column]$77 and another after $[Column2]$75.
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!