How to Create a To Do List, Task List - Google Sheets Template
Вставка
- Опубліковано 29 вер 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!
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.
Great tutorial, easy to follow, well-explained and very useful. Keep coming with these gems!
Please do an advance version, this was so helpful.
This was so incredibly helpful!
Can you please make a copy of this available?
I was thinking about this, he just did it...thanks
Thanks!
Thank You!
✌🏻✌🏻✌🏻 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... ✌🏻✌🏻✌🏻
Great 👍
I wish you would have started from a blank sheet & showed how to build from there.
how can i get this code?
Advance version pls !!!
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?
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.
After 2 hours, I gave up
I wish this is done for Google webapp
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
Please make the advance video! ✌🏻
Teacher...yours works so much better than the one I created... LoL!
You can add the auto sort function like you did in the last video to this todo list.
I've opened the script editor from the spreadsheet, but I got a typeerror
TypeError: Cannot call method "getActiveSheet" of null.
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
Teacher,
Pls pls
Recurring task how to create/ one-time / daily / weekly/ month/ half-monthly make the tutorial.
I like the macro the most! Awesome~thanks body😄
function always() {
const English = perfect;
const theme= perfect;
const explanation = perfect;
const solution= perfect}
You're missing a semicolon in the end :)
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
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.
Thanks from the Philippines!
Great video tutorial
TypeError: Cannot read properties of undefined (reading 'source')
Got it
Got it
Thanks a lot, very useful. I have a question: is it possible to hide the check box if field are empty?
Please make a video creating an automated FIFO inventory🙏🏼🙏🏼
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?
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.
Activen la traducción en la configuración de UA-cam Studio.
Google Forms to Google Groups with custom domain
please
Sir whatsapp messages bulk send sricpt post it sir
What should I do if I want to add more than one timestamp??
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
We don't need to ask you what we are looking for, somehow you have ability to understand what we need. 😃 Thanks a lot 👍
Still making guide videos to this day, got to appreciate it. Thanks.
I'm going to vote for an advanced version! I'd love to see your technique for that.
awesome dude, well done. im sorted! u rock!
Can I have copy of the Code or this sheet
Thanks
Love from india
how to repeat a static task?
YOU ROCK!!! LIFE-SAVER!
very good content...
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.
please do advance video
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?
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 ua-cam.com/video/lc8-vJ5r3e0/v-deo.html
@@ExcelGoogleSheets Im gonna check it out! Thanks!
Thank you!
so cool,
Helpful.
Best Google Sheets and Excel tutos! good job!
Thanks a lot!
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.
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