Google Sheets - Create an Interactive Task List

Create a to-do list in Google Sheets that formats tasks with a strike-through automatically when a checkmark is clicked.

Learn more from Prolific Oaktree:

#prolificoaktree #googlesheets #checkbox

[videocentric]

Excellent tutorial. Thank you for not making this longer. Perfect length to understand what I was looking to do! Great job!

[adelaidenanaagyemang]

Amazing video! I watched the entire video first, then opened sheets and felt confident enough to try my own interactive to-do list and voila! I'm starting a new career and have things I need to complete and was swimming in paper to-do lists thank you so much for a great lesson

[TheLampVideos]

Just what I needed with no unnecessary fluff. Thank you and thank you!

[richardlionheart]

Your videos are fantastic, you should be the voice of the internet. So calm and precise. If we all had teachers like this the world would be a better place.

[gabrielfernando]

I'm in awe, such a complete video in 3 minutes, that is just so satisfying

[kevinp]

This is so clear and to the point and the slow patient voice really helps someone who is new to google sheets. A great service to mankind you have done, Sir.

[kathleenbarquin]

Oh, YES - exactly, exactly what I was looking for. Thank you!

[onesandzeroes]

You don't need to do ctrl+c / ctrl+v with the checkboxes. You can just drag the little box in the corner of the frame surrounding the checkbox.

[billlane]

That was so helpful. We wanted to make a weekly assignment tracker for our distance learning kids. This nailed it. : )

[Dijarenuka]

This was great! Easy to understand and I appreciate your calm voice

[rufrida]

Thank you for this short and easy to understand tutorial. I was able to create my own task list by watching your video only once.

[jenniesapitula]

really great! What if there are two checkboxes though and I want the category slashed through only when both check boxes are ticked? Thanks

[MvKoski]

Thank you! Simple, clear and straight to it! Looking forward to learning more from you!

[thevivesociety]

Thanks for making this video. How do you re-arrange the items on your checklist? Like if you want to move smores to the second row?

[kamleshpatel]

Thank you, very simple and easy to follow/accessible instructions

[zolasky]

Thank you for this! Short, simple and informative!

[Lairy]

Thanks for this, can you set the "grow a tree" to a numerical value ? i have my accounts on a spreadsheet and when i tick the box i want to the amount to go from say £209.00 to £0, then when I untick goes back to the original amount....thanks very much.

[vladimirbulut]

Thank you so much for showing this. I have been waiting on Google from this for a long time. Is it possible to add one more step. When you click on the checkbox, it will strikethrough the task and also place today's date or the date when it was checked?

[timelesstimesgoneby]

So I’m trying to make it change only when there’s new info checked and color it differently time stamp but everything I have tried to do changes the date even when there’s no new total check boxes

[GenealogyTV]

You taught me something new today. Thanks!