Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How do I get a count of all the field records in the same table?

Topic Labels: Formulas
229 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

Sorry if this is a basic question, but I just can’t seem to figure it out. I’m trying to get a count of all the records within the same table. So for e.g. say I have two columns in a table as depicted below.
Screen Shot 2021-03-03 at 09.18.04

I’m trying to have the “Count of all Tasks” column be dynamic so that when one more record is added, the number changes to 5 and so on. The reason is that I need to lookup this total count number into another table.

However, I’m not sure how to proceed. I can’t seem to use a Rollup or a Count type for the “Count of all Tasks” column because they need me to refer to another table. In essence, I’m trying to rollup a count of all values in the same table. I’m pretty sure this should be fairly easy and I have a blind spot here.

Any help is much appreciated.

Thanks.

0 Replies 0