Unable to group or summarize by contact column

Answers
-
Hi @Steve K
The original discussion was almost a year ago. I gave it a fresh look, and here is a solution.
The Source Sheet with Contact Lists checks the Group List sheet like the second image and checks the Group A, B, and C columns with the formula like these;
[Group A] =IF(HAS(COLLECT({Group List Range : Group}, {Group List Range : Contacts}, HAS([Contact 1]@row:[Contact 3]@row, @cell)), "A"), 1)
[Group B] =IF(HAS(COLLECT({Group List Range : Group}, {Group List Range : Contacts}, HAS([Contact 1]@row:[Contact 3]@row, @cell)), "B"), 1)Using the value of those Group A-C checkboxes as a filter, we can build reports that group projects by group.
-
Hi @Steve K
Even if only one option is in the cell, if the Column is set up to allow multiple contacts then you won't be able to use that column for grouping. Can you check the column properties (double click on the column name) in the source sheet?
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives