Re: Count values and show the sum on a different table
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
