Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Total a full table and percentage complete

2389 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Is it possible to total a full table and calculate the % complete?


InfoClientsInvite AcceptedTotal CountPercent Accepted
InfoClient A
Client B
Client C
Client D

If I have invited all 4 clients to an event but only 2 have confirmed, I have 50% done. Can Airtable calculate this?

I'm looking for it to trigger a completed task in another tab once it hits 100% - is that possible?

1 Reply 1

@jsargent- the way to do this is to have another table where you can count or rollup values from the invites table, e.g an events table (see screenshot attached)