How to Create a To Do List, Task List - Google Sheets Template
HTML-код
- Опубликовано: 14 окт 2024
- Learn how to create an interactive To Do list or a Task list in Google Sheets. We'll create e template with various conditional formatting applied as well as automatic timestamps to mark when the tasks were completed.
Sign up to get updates, practice files and code snippets eepurl.com/hwyGg1
#todo #tasks #googlesheets
The way you troubleshoot sheets and the coding is very refreshing. Great teacher!
Omg yes! Thank you! And the advanced one where you move items when done?! YES PLEASE!
I am building my own system for keeping tabs on my brewery and your videos has tought me 98% of everything I use!
You had me sold when you said 'Brewery'!
But, yes, I am looking forward to the advanced one as well.
An excellent video, as usual. It would be fantastic if you could do the advanced level and send the completed task to another sheet and also to take into account repetitive tasks, for example activities done daily or once every two weeks, etc. Is there a way to make them appear in the to do list automatically?
Still making guide videos to this day, got to appreciate it. Thanks.
Great video tutorial. I love the explanation of debugging the script when it didn't produce the correct results. I love your tutorials integrating spreadsheets with scripts bringing all kinds of services into the overall functionality. Nice job.
Please do an advance version, this was so helpful.
When I watch videos, it's fun and I feel like I'm playing a game and it's better than watching a movie or a funny clip
World's No 1 Channel
World's Best Teacher
World's Best Quality
Learn Easy and Understand
I Love And Like All Video
All Video Is Heart 💓 Touching
We don't need to ask you what we are looking for, somehow you have ability to understand what we need. 😃 Thanks a lot 👍
Teacher...yours works so much better than the one I created... LoL!
Thanks from the Philippines!
Great tutorial, easy to follow, well-explained and very useful. Keep coming with these gems!
Hi, first of all, a compliment for your videos, clear on all the points. I would like to know if there is a way to get integration between google Sheets to google tasks. Thanks for your kind response.
This was so incredibly helpful!
I like the macro the most! Awesome~thanks body😄
Best Google Sheets and Excel tutos! good job!
Thanks a lot!
You can add the auto sort function like you did in the last video to this todo list.
Thanks a lot, very useful. I have a question: is it possible to hide the check box if field are empty?
Can you please make a copy of this available?
I'm going to vote for an advanced version! I'd love to see your technique for that.
I've always like your tutorials 👍, I got promoted as a managerial position on my last Job. Is there any chance that you'll make a tutorial or a separate channel for Google Sites?
Great video tutorial
✌🏻✌🏻✌🏻 Hi, love your videos... the raw style of your videos is refreshing... By the way, I would love to see you make some videos about how to use google charts (bar, time-line, pie, Iine, calendar charts) or chart.js in google sheets... maybe userform IvI 4... or a new web app part... or a new series, google chart series... ✌🏻✌🏻✌🏻
I was thinking about this, he just did it...thanks
YOU ROCK!!! LIFE-SAVER!
your videos are always great. How can we easily create data entry form with around 20 columns and lot of drop down and all data coming goes to the spreadsheet.
awesome dude, well done. im sorted! u rock!
I've opened the script editor from the spreadsheet, but I got a typeerror
TypeError: Cannot call method "getActiveSheet" of null.
Thanks
Love from india
function always() {
const English = perfect;
const theme= perfect;
const explanation = perfect;
const solution= perfect}
You're missing a semicolon in the end :)
Thanks!
Thank You!
Great video, as always sir
Great video!!! Could you please make a video creating a Google Apps Script emulating a VLookup function for a google Sheet? I'm really having trouble developing it!
If I'm not mistaken, this video should cover it ruclips.net/video/lc8-vJ5r3e0/видео.html
@@ExcelGoogleSheets Im gonna check it out! Thanks!
Please make the advance video! ✌🏻
Thank you!
I submitted the comment yesterday, but cannot see in my comment section. Hence new comment here on.
My Code at 28:30 min is stuck without giving any debug result / error (blank), except "No logs are available for this execution". As and where the "TRUE" value been replaced in debugging as per the tutorial in sheet after checkbox=true, but completed on date did not execute as per your successful attempt. As checked in script the execution returned "No logs are available for this execution". I reverified repeatedly but no issues.
The console highlighted for reported "A form field element has neither an id nor a name attribute. This might prevent the browser from correctly autofilling the form.
To fix this issue, add a unique id or name attribute to a form field. This is not strictly needed, but still recommended even if you have an autocomplete attribute on the same element."
Please help for the issue
Great 👍
very good content...
A simple "Completed On" timestamp equation: =IF(A3=TRUE,IF(D3"",D3,NOW()),"") A3 - done column, D3 - completed column. Make sure your timezone is updated in google sheets: File - Spreadsheet settings - Time Zone
What’s the range?
NOW() will be updated every time you open google sheet
I wish this is done for Google webapp
I wish you would have started from a blank sheet & showed how to build from there.
Teacher,
Pls pls
Recurring task how to create/ one-time / daily / weekly/ month/ half-monthly make the tutorial.
Please make a video creating an automated FIFO inventory🙏🏼🙏🏼
Helpful.
so cool,
What should I do if I want to add more than one timestamp??
Can I have copy of the Code or this sheet
Will you ever make a video about adding authentication to google web app?
Unless Google creates an easier way to do this, then probably the answer is no, because with currently available methods this video would be 8 hours long.
TypeError cannot read property 'source' of undefined
at addTimestamp(code 6:24)
at onEdite (code 2:3)
Plz help me to fix this error
I too had a problem and sought the help to figure out from the teacher and awaiting far long. Hope the teacher would look and have his meagre solution
I was stuck with all types of errors. Just had to remove the scripts I started, then went to the sheet I was using and went to the apps script editor from the extensions/tools... no more errors....as of yet. Hope this helps
how can i get this code?
Activen la traducción en la configuración de RUclips Studio.
My app script show: "TypeError: Cannot read property 'source' of undefined. Can someone help me with this?
You shouldn't not manually run the code. You run the code by making changes to the spreadsheet.
@@ExcelGoogleSheets what does this mean?
my script code don't function why?
I am facing the same issue. pls have your project status as of now, weather it is solved or not. an any kinda solution please update
I was stuck with all types of errors. Just had to remove the scripts I started, then went to the sheet I was using and went to the apps script editor from the extensions/tools... no more errors....as of yet. Hope this helps
Google Forms to Google Groups with custom domain
please
I wish you were a more interactive tutor. There's so many great videos but never any feedback
I'm not sure what feedback you need. As a rule, I don't answer open ended questions.
@@ExcelGoogleSheets feedback in the comments section of most videos. Haven't seen any responses to a lot of the questions asked. but thanks for commenting here, so I know now, that you see the comments and will respond.
@@justbelit I do see most comments. If I don't reply to them that means it's just an open ended question. Very often I see questions that are essentially similar to "Is it possible to build a car?". I'm not sure how to answer these type of questions, so I just don't.
TypeError: Cannot read properties of undefined (reading 'source')
Got it
Got it
how to repeat a static task?
please do advance video
Advance version pls !!!
After 2 hours, I gave up
Sir whatsapp messages bulk send sricpt post it sir