A five-checkpoint inspection needs a compact progress cue beside each item. Show filled circles for completed checks and open circles for the remainder, while keeping the counts available for sorting and reading.
Repeat two symbols from the numeric counts
Put the completed count in B2 and total count in C2. In D2, use this display formula:
=REPT("●",B2)&REPT("○",C2-B2)For 3 of 5, it produces ●●●○○. The cells B2 and C2 stay numeric, so use those for calculations and filters.

Illustrated strip. Keep the actual count in adjacent cells.
Check the endpoints before filling down
For 0 of 5 you should see five open circles. For 5 of 5 you should see five filled circles. Validate that the counts are whole numbers and that completed is between zero and total. If your font shows boxes in place of circles, use visible characters such as X and - and keep a text count like “3 of 5” nearby.

Illustrated boundary check. Verify the display at both ends.



