Not getting the result you're looking for? It's not your fault! There are some confusing nuances to these functions. Watch this video to understand which function you need for the outcome that you want.
Airtable Official Function Definitions:
https://support.airtable.com/docs/formula-field-reference#numeric-operators-and-functions
Airtable formula for counting a Multiple-Select Field:
https://support.airtable.com/docs/counting-the-number-of-options-in-a-multi-select-field
⭐️ Part of a business or enterprise team?
Access my services - https://www.3rings.co
⭐️ Product Comparisons
Airtable vs Excel - https://youtu.be/RHFvUmptIs0
Airtable vs Notion - https://youtu.be/kFJ6ddr3lVI
⭐️ Airtable Basics
Airtable for Beginners - https://youtu.be/XoJJwSgrIJM
Linked Records - https://youtu.be/nYuHW-U6nnE
How Dates Work - https://youtu.be/PLHQ4wKiOxY
Sign up for Airtable with my affiliate link (thank you!) - https://airtable.com/invite/r/R3UWDio5
To Do List Template - https://www.3rings.co/resource/list-eater
Inventory Template - https://www.3rings.co/resource/clothing-inventory
Expense Reimbursements Template - https://www.3rings.co/resource/expense-reimbursements
Chapters
0:00 - Intro
0:23 - Definitions COUNT, COUNTA, COUNTALL
1:02 - Why COUNT doesn't really work in a formula field
4:24 - How to count Linked Records
4:58 - How to count with a Rollup
7:19 - Count the items in a Multiple Select field
8:29 - Conclusion: always use a Rollup
9:07 - Outro