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

Topic Labels: Formulas
2220 2
Showing results for 
Search instead for 
Did you mean: 
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! 

2 Replies 2
6 - Interface Innovator
6 - Interface Innovator

@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: