What's the difference? COUNT vs COUNTA vs COUNTALL
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/for...
Airtable formula for counting a Multiple-Select Field:
https://support.airtable.com/docs/cou...
⭐️ Part of a business or enterprise team?
Access my services - https://www.3rings.co
⭐️ Product Comparisons
Airtable vs Excel - • Airtable vs Excel and Google Sheets
Airtable vs Notion - • Is Airtable better than Notion??
⭐️ Airtable Basics
Airtable for Beginners - • Learn Airtable in 8 minutes
Linked Records - • Understanding Airtable’s MOST POWERFUL fea...
How Dates Work - • How Dates Work in Airtable
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-e...
Inventory Template - https://www.3rings.co/resource/clothi...
Expense Reimbursements Template - https://www.3rings.co/resource/expens...
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