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