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.
