What's the difference? COUNT vs COUNTA vs COUNTALL

Published: 03 October 2022
on channel: Julian Post
999
32

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 POWERFU...  
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


Watch video What's the difference? COUNT vs COUNTA vs COUNTALL online without registration, duration hours minute second in high quality. This video was added by user Julian Post 03 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 999 once and liked it 32 people.