Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Total a full table and percentage complete

164 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Example:

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)