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.
Dec 01, 2022 01:31 PM
Is it possible to total a full table and calculate the % complete?
Example:
Info | Clients | Invite Accepted | Total Count | Percent Accepted |
Info | Client 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?
Dec 01, 2022 01:55 PM
@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)