Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Count values and show the sum on a different table

Topic Labels: Automations Formulas
586 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

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