Formula to add multiple select data

[Scott_Hedges]

I have a field that has a drop down in each cell. I want to create a formula that will count the total number of names selected in the field. Here’s a screenshot of the field.

This formula for the screenshot above would show a total count of 7.

I also want to be able to create a formula that counts the number of each possible selection. The results of this formula would show:
Carlo - 2
Zach - 2
Mark - 2
Ryan - 1

Thank you in advance for your help!

[Williams_Innova]

Hi @Scott_Hedges,

Welcome to the community!

This best way I imagine this being achieve is to have a separate table for names and link the names when needed, instead of using a multi-select field. You would be able to set count fields in each table. This method would easily allow you to have a count for each name, as well as count each name.

Thanks,
Chris

Williams Innovations

Information Ecosystem | Williams Innovations

Williams Innovations offers consulting and management services for Airtable, information and communication structures, process mapping, and content development.

[Scott_Hedges]

Thank you VERY much for the advice. I’m a complete Newbie to Airtable. Can you elborate on what you mean by a separate table for name and linking the names? Is there specific language I need to use to research help articles on this?

[Williams_Innova]

Hi @Scott_Hedges,

No worries. Starting something new is the first step to becoming an expert.

Below is a link to an Airtable support article that talks about creating new tables and linking them.

Airtable Support

Getting started: making new tables and linking records

If you've been following along with this guide, your table is starting to look pretty robust, with different field types and a variety of different views. (If you haven't been following along with...

Let me know if you have any more questions.

Chris

Williams Innovations

Information Ecosystem | Williams Innovations

Williams Innovations offers consulting and management services for Airtable, information and communication structures, process mapping, and content development.

[Scott_Hedges]

OMG, the capabilities of Airtable just continue to impress and amaze me!
Linking tables is cool. I think I figured it out! Thanks for the guidance.

[Williams_Innova]

Hi @Scott_Hedges,

Yeah, Airtable is great and the capabilities of is are amazing. A very useful tool for sure. Feel free to reach out here anytime you have any questions. The community is just as great as the tool.

Thanks,
Chris