Help

Display Multiple Select Responses

Solved
Jump to Solution
566 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Auntee_Rik
4 - Data Explorer
4 - Data Explorer

I have a field with multiple select; I need to get a count of EACH selection AND would like to display each response with the count. For background: the field is part of a survey and those filling out the form choose all that apply to them.

I tried the linked field route and it counts everything in the field; doesn’t separate them. Do I have to do a linked field for EACH option?

I’ve looked at several related items in the community but it all reads like a foreign language that I don’t speak to me…

1 Solution

Accepted Solutions
Auntee_Rik
4 - Data Explorer
4 - Data Explorer

Closing because I found 2 solutions:

a) pivot table extension

b) copying the table, then use Linked Records and creating a formula column for each response; formula: FIND(“Value I’m looking for”, {Column to look in}) > 0

Screenshot 9-1-2022 5-16-11 PM

See Solution in Thread

1 Reply 1
Auntee_Rik
4 - Data Explorer
4 - Data Explorer

Closing because I found 2 solutions:

a) pivot table extension

b) copying the table, then use Linked Records and creating a formula column for each response; formula: FIND(“Value I’m looking for”, {Column to look in}) > 0

Screenshot 9-1-2022 5-16-11 PM