Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Display Multiple Select Responses

Solved
Jump to Solution
138 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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