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?