Help

Count values and show the sum on a different table

Topic Labels: Automations Formulas
167 1
cancel
Showing results for 
Search instead for 
Did you mean: 
SLMaho
4 - Data Explorer
4 - Data Explorer

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!

Table1.png

Table2.png

  

1 Reply 1
Pascal_Gallais-
6 - Interface Innovator
6 - Interface Innovator

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:

Pascal_Gallais_0-1719420370954.png

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

 

Pascal_Gallais_2-1719420442510.png

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:

Pascal_Gallais_3-1719421989974.png

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":

Pascal_Gallais_4-1719422116335.png

Regards,

Pascal