Skip to playerSkip to main contentSkip to footer
  • 7/2/2025
Discover how you can track project progress using Sparklines and COUNTIF functions in Google Sheets.

By the end of the video, you'll be able to answer the following questions.
google sheets progress bar with percentage
google sheet sparkline examples
sparkline progress bar google sheets
google sheets progress bar conditional formatting
google sheets sparkline progress bar with text
progress bar google sheets template
sparkline google sheets
google sheets progress bar checkbox

Create Project Tracker
1) Select cell B3
2) Insert ~ Checkbox
3) Do the same for the rest of the columns.
Ctrl+C to copy, and Ctrl+V to paste.
4) =SPARKLINE(COUNTIF(B3:F3,TRUE),{"CHARTTYPE","BAR";"MAX",5;"COLOR1","GREEN"})
5) Apply to all rows



google sheets progress bar with percentage,
google sheet sparkline examples,
sparkline progress bar google sheets,
google sheets progress bar conditional formatting,
google sheets sparkline progress bar with text,
progress bar google sheets template,
sparkline google sheets,
google sheets progress bar checkbox,
Transcript
00:00If you want to create a project tracking spreadsheet in Google Sheet, stick around, I'll show you how this is done.
00:05Let's first start off by introducing some checkbox right underneath Draft.
00:08You're gonna go Insert, Checkbox.
00:11Then you press Ctrl C and move to the next column.
00:14Ctrl V to paste it, Ctrl V, paste it, paste it, paste it.
00:17That completes your checkbox.
00:19Use this formula on the progress bar.
00:22Let's dissect the formula a bit here.
00:28On a sparkline, the first argument count if actually counts the number of checkbox.
00:32The second set of argument describes the characteristic of the bar chart here.
00:36The first one says the bar.
00:38The second one, maximum five, is I've got five checkbox.
00:41That's why I put five.
00:42If you have three, just change it to three.
00:44And the final one is basically highlighting the color of the bar chart.
00:47Now I'm gonna apply for the rest of the rows like this.
00:51Then now if I were to start checking the checkbox, you can see that the bar chart starts to grow like that.

Recommended