Part 3/6:
Use the
COUNTIFfunction to count how many checkboxes are checked in the respective employee’s row. This can be done by typingCOUNTIF(G3:J3, TRUE), where G3 through J3 contains the checkboxes.Construct the full formula, which will look something like this:
=SPARKLINE(COUNTIF(G3:J3, TRUE), {"charttype", "bar"; "max", 4})
In this example, max is set to 4 since there are four steps in the certification process.
Entering the Formula Correctly
If there is an error in the formula, such as spelling COUNTIF incorrectly, it can be easily corrected by clicking on the formula bar, identifying the mistake, making the necessary changes, and hitting enter.