Help

Need help with a checkmark completed formula

Topic Labels: Formulas
492 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Melissa_Kowaluk
4 - Data Explorer
4 - Data Explorer

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
momentsgoneby80
7 - App Architect
7 - App Architect

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.

exampla