Creating conditional formula that doesn't calculat...

[Melissa_Kowaluk]

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!

[momentsgoneby80]

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.