Upgrade Your To Do Lists in Google Sheets

Here’s the spreadsheet with both the scripts: docs.google.com/spreadsheets/d/1srOUSCFsoMiaojDlR0wHYT77VvfC3yJQRG7v293gyGo/copy
Sure, checkboxes exist. But what can we do with them? We'll, this video will show you just one option! And don't worry, there's more where this came from!
----------------------------------------------------------------------------------------------------
⏳ TIMESTAMPS
----------------------------------------------------------------------------------------------------
0:00 Intro
0:14 Jotform
0:43 Setup
2:02 Apps Script
3:21 A Kanban in Google Sheets?!
3:46 Kanban Setup
4:10 Kanban Script
4:35 The Ultimate Premade Content Tracker!
----------------------------------------------------------------------------------------------------
💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓

[@HashAliNZ]

So many projects these could be used for! What are you working on that this will help with?

[@EmzDiary]

I forget things all the time, so I have multiple alarms going off on my iphone, and calendar alerts set up as well. -Emily from #vrafam

[@TechyFriends]

Do you have to change the name "Content Tracker" in the script to your sheet's name?

[@daisyherpin]

Best tutorial I've ever seen!

[@EmzDiary]

Very helpful video! I subscribed to your channel as well. I need to make more to do lists online, such as social media planning and what videos I plan on using for my KZbin.

[@HashAliNZ]

Glad it was helpful! Check out this video for planning system. It's not just for videos, but could be used for podcasts, blog posts, and works in perpetuity! kzbin.info/www/bejne/aKLHhJR4aNKbhNk

[@MarioSchoeman]

Thank you very much this video was very helpfull, I seen many on Kanban Boards, How would I add a hyper link or link on the Kanban when clicked would take you to the selected record?

[@HashAliNZ]

@@MarioSchoeman good idea. I'll try add that functionality in

[@quetzalcoatlgarcia7887]

Hi!! Great work it was very helpful to me for project management, but I have one question is it possible to limit the script? I am using it in a kanban format with 3 columns: to do, doing and done. I would like the info stay fixed in the last column (done) and when I check the box it no longer moves to another column . Thanks man!! you are awesome

[@HashAliNZ]

Absolutely. In the script shown in the video I've got if(r21) {return} Just change this to if(c>2) {return}

[@zahirahzainalalias6856]

Can script kanban checkboxes be used for dropdown as well? Thank you in advance!

[@HashAliNZ]

Like this? kzbin.info/www/bejne/aKLHhJR4aNKbhNksi=igvog5mlzQN_-mbw

[@MitziOquino]

Hi! THank you so much. This is useful! I have issues tho. It says in this part " if(e.value != 'TRUE'){return}" that "e" is undefined

[@HashAliNZ]

onEdit functions are meant to be run from the Apps Script Editor. They run from the spreadsheet itself.

[@daisyherpin]

If I accidently check the wrong box, how can I undo so that it reverts it back to the jobs tab?

[@HashAliNZ]

Ctrl+Z. It takes several steps to move an item correctly, so it may take up to three Ctrl+Zs