This is the formula that I use:
- To calculate the percentage:
=IFERROR(COUNTIF(B6:B15,TRUE)/COUNTA(C6:C15),0) - To insert a progress ring into the planner:
=IFERROR(INDEX('Set Up'!C2:C22, MATCH(B16, {0%, 5%, 10%, 15%, 20%, 25%, 30%, 35%, 40%, 45%, 50%, 55%, 60%, 65%, 70%, 75%, 80%, 85%, 90%, 95%, 100%}, 1%)),"")
Note: You need to adjust the data range (e.g., 'Set Up'!C2:C22) according to your own spreadsheet.
