Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to Count Number of Selected Options in a Multiple Select Field Using Formulas

Topic Labels: Formulas
4641 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Charles_Turner
4 - Data Explorer
4 - Data Explorer

I have a multiple select field with four options: 2020, 2021, 2022, 2023. 

I want a formula field that prints how many of these options were selected. 

I played a bit with Count and If statements, but couldn't get anything to function quite right. 

Any help appreciated! 

4 Replies 4
airballer86
7 - App Architect
7 - App Architect

@Charles_Turner I was trying to find the same thing and @bruceconsulting has an easier formula that doesn't require turning the multiple select in to a lookup table: https://community.airtable.com/t5/formulas/creating-an-if-statement-for-multiple-options-in-a-field/... 

What do you mean? It's exactly the same formula.

@Elias_Gomez_Sai yes. That was over a year ago, I never responded to say that.