Upgrade Your To Do Lists in Google Sheets
Вставка
- Опубліковано 9 лип 2024
- Here’s the spreadsheet with both the scripts: docs.google.com/spreadsheets/...
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 ↓↓↓ - Навчання та стиль
So many projects these could be used for!
What are you working on that this will help with?
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
Do you have to change the name "Content Tracker" in the script to your sheet's name?
Best tutorial I've ever seen!
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 UA-cam.
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! ua-cam.com/video/2qdSaB3mhNw/v-deo.html
If I accidently check the wrong box, how can I undo so that it reverts it back to the jobs tab?
Ctrl+Z. It takes several steps to move an item correctly, so it may take up to three Ctrl+Zs
Can script kanban checkboxes be used for dropdown as well? Thank you in advance!
Like this? ua-cam.com/video/2qdSaB3mhNw/v-deo.htmlsi=igvog5mlzQN_-mbw
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
Absolutely. In the script shown in the video I've got if(r21) {return}
Just change this to if(c>2) {return}