
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 19, 2023 11:02 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 19, 2023 11:22 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 23, 2023 01:51 PM
@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/...

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 11, 2024 04:56 AM
What do you mean? It's exactly the same formula.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 11, 2024 09:53 AM
@Elias_Gomez_Sai yes. That was over a year ago, I never responded to say that.
