Skip to main content

Hi! I'm new to Airtable and am very stuck here trying to achieve counting a number of records and showing it in a different table.

The columns I want to count are: "Plege1", "Pledge2" and "Pledge3" in "Table1", count the number of "True" entry of all three columns, sum up and record the number in "Table2".

I was able to create a formula to count the number of "True" entry for each record, but I can't think of a way to show the sum of all records in "Table2". 

Could someone help with this? Any suggestion is very much appreciated. Thank you!

  

Hello,

Here is a possible solution. There may be a simpler way to do it, but not of my knowledge.

I have created the following table to match your issue:

And a summary table to compute what your are looking for:

 

To achieve this, do the following

-1- Create a table summary with a single field "summary_id" of type number with no decimals.

Insert only 1 line in this table with value "1" in the field summary_id

-2- Insert a filed "summary_id" in the first table, type "link to another record" and link it to table summary.

Set the value to "1" for all lines of your table.

-3- Go back to summary table and insert the field Pledge1_Total:

Do the same for Pledge2_Total and Pledge3_Total with counting conditions set on respective table1 fields

-4- In summary table, add a formula field "Pledge1-3_Total":

Regards,

Pascal


Reply