Skip to main content

Total a full table and percentage complete

  • December 1, 2022
  • 1 reply
  • 17 views

Forum|alt.badge.img

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

JonathanBowen
Forum|alt.badge.img+18

@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)