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.
Comments