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.

Need help with a checkmark completed formula

Topic Labels: Formulas
291 1
Showing results for 
Search instead for 
Did you mean: 

For context, I am 100% not an excel whiz, so formulas in general are foreign and difficult. I am trying to create a field that creates a “completion rate” so an average of completed / incomplete tasks based on the checkmark field. For context, I am trying to determine if our team is maintaining at least an 80% completion rate on our tasks. Can anyone help me with this formula? Thank you!

1 Reply 1

Hi @Melissa_Kowaluk!
You don’t actually need a formula in a field for this.

You can simply select “Percentage checked” or “Percentage Unchecked” in the bottom/footer of the field you want to know the percentage of checked boxes of. You will see the summary option when you hover over the footer for that field. Click in it to see the options and select whatever option fits your needs best.