Counting and Outputting Unique Values

[conc]

I'm working with a relatively simple table with columns for room number, name, and dietary restrictions. Dietary restrictions will be a dropdown multi-select column.

Room	Name	Restrictions
1	John	Halal, Diabetic
2	Sally	Halal
3	Jane	Halal, Diabetic
4	Mike
5	Kim	Halal, Diabetic, No Pork

What I'm hoping to achieve is a count of the unique values, so in my example above:

Halal, Diabetic 2

Halal 1

Halal, Diabetic, No Pork 1

None 1

Can I do this?

[Sistema_Aotearo]

Not sure if this will work, but you could try:

IF({Restrictions},LEN({Restrictions})-LEN(SUBSTITUTE({Sustainability ChecklistRestrictions},",",""))+1)

[ScottWorld]

Here are 2 different ways of doing this:

1. Group your current table by dietary type. Airtable will display the count above each group.

or

2. You can convert your multi-select field to a linked record field. That will move the dietary restrictions to their own table, and each dietary restriction will be linked to one or more people. In that new table, you can create a Count field (”count” is a special field type), which will count the number of people for each dietary restriction.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

[conc]

I'd like to try both, but where should I be seeing the count above each group?

[ScottWorld]

You'll have to group it first, and then a "summary bar" will appear above each group.

[conc]

Oops!

Thank you!

This is a very promising start.