Тёмный

How to Create a To Do List, Task List - Google Sheets Template 

Learn Google Sheets & Excel Spreadsheets
Подписаться 277 тыс.
Просмотров 73 тыс.
50% 1

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

Опубликовано:

 

8 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 83   
@buredabby
@buredabby 3 года назад
The way you troubleshoot sheets and the coding is very refreshing. Great teacher!
@harkelin
@harkelin 3 года назад
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!
@roostewrum
@roostewrum 3 года назад
You had me sold when you said 'Brewery'! But, yes, I am looking forward to the advanced one as well.
@alliillilliii4365
@alliillilliii4365 3 года назад
Still making guide videos to this day, got to appreciate it. Thanks.
@dogankorkmaz1208
@dogankorkmaz1208 3 года назад
We don't need to ask you what we are looking for, somehow you have ability to understand what we need. 😃 Thanks a lot 👍
@victoriaporceljuarez7105
@victoriaporceljuarez7105 3 года назад
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?
@AGMineo
@AGMineo 3 года назад
Please do an advance version, this was so helpful.
@FunSpiritman
@FunSpiritman 3 года назад
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.
@FilipinoSpreadsheets
@FilipinoSpreadsheets 3 года назад
Thanks from the Philippines!
@tanveerhussain3881
@tanveerhussain3881 3 года назад
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
@cheewurz
@cheewurz 3 года назад
Teacher...yours works so much better than the one I created... LoL!
@salutsn
@salutsn 3 года назад
I like the macro the most! Awesome~thanks body😄
@ymarcellus6763
@ymarcellus6763 3 года назад
Great tutorial, easy to follow, well-explained and very useful. Keep coming with these gems!
@Mohammedbasim
@Mohammedbasim 3 года назад
You can add the auto sort function like you did in the last video to this todo list.
@letmeexcel5943
@letmeexcel5943 3 года назад
Can you please make a copy of this available?
@parsleyhao1648
@parsleyhao1648 Год назад
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.
@charlottehadfield7938
@charlottehadfield7938 Год назад
This was so incredibly helpful!
@CaioGaioski
@CaioGaioski 2 года назад
Best Google Sheets and Excel tutos! good job!
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
Thanks a lot!
@tiepnvslhpp
@tiepnvslhpp 3 года назад
Great video tutorial
@russellgregory1537
@russellgregory1537 3 года назад
I'm going to vote for an advanced version! I'd love to see your technique for that.
@temyraverdana6421
@temyraverdana6421 3 года назад
Thanks a lot, very useful. I have a question: is it possible to hide the check box if field are empty?
@mhoamaintenance1706
@mhoamaintenance1706 3 года назад
I was thinking about this, he just did it...thanks
@LTSYT
@LTSYT 3 года назад
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?
@vikassallan7440
@vikassallan7440 3 года назад
Thanks Love from india
@milance012
@milance012 3 года назад
✌🏻✌🏻✌🏻 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... ✌🏻✌🏻✌🏻
@MitchRSA
@MitchRSA 3 года назад
awesome dude, well done. im sorted! u rock!
@ruthmonsanto6592
@ruthmonsanto6592 3 года назад
YOU ROCK!!! LIFE-SAVER!
@vinodkumarPrajapativnd
@vinodkumarPrajapativnd 3 года назад
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.
@alexpueblag
@alexpueblag 3 года назад
Please make the advance video! ✌🏻
@muhammedaadhil5645
@muhammedaadhil5645 3 года назад
I wish this is done for Google webapp
@dewaynewest7756
@dewaynewest7756 4 месяца назад
I've opened the script editor from the spreadsheet, but I got a typeerror TypeError: Cannot call method "getActiveSheet" of null.
@emilianoreyes
@emilianoreyes 3 года назад
Thank you!
@alainsteveabahbidias5864
@alainsteveabahbidias5864 2 года назад
Great 👍
@A_Pinch_Of_Salt
@A_Pinch_Of_Salt Год назад
Thanks!
@ExcelGoogleSheets
@ExcelGoogleSheets Год назад
Thank You!
@stationeryhubshop
@stationeryhubshop 3 года назад
very good content...
@QuadDrums
@QuadDrums 3 года назад
Great video, as always sir
@agrofamily1986
@agrofamily1986 3 года назад
function always() { const English = perfect; const theme= perfect; const explanation = perfect; const solution= perfect}
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
You're missing a semicolon in the end :)
@jcrnda
@jcrnda 3 года назад
Helpful.
@LP-ig8tg
@LP-ig8tg Год назад
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
@ronj5714
@ronj5714 2 года назад
I wish you would have started from a blank sheet & showed how to build from there.
@danielgm98
@danielgm98 3 года назад
Please make a video creating an automated FIFO inventory🙏🏼🙏🏼
@fabricio_zm
@fabricio_zm 3 года назад
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!
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
If I'm not mistaken, this video should cover it ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lc8-vJ5r3e0.html
@fabricio_zm
@fabricio_zm 3 года назад
@@ExcelGoogleSheets Im gonna check it out! Thanks!
@ireefer3508
@ireefer3508 3 года назад
so cool,
@michellemendoza891
@michellemendoza891 3 года назад
What should I do if I want to add more than one timestamp??
@ajadsingh1652
@ajadsingh1652 Год назад
Teacher, Pls pls Recurring task how to create/ one-time / daily / weekly/ month/ half-monthly make the tutorial.
@ragininarang3240
@ragininarang3240 3 года назад
Can I have copy of the Code or this sheet
@courtneyberry3693
@courtneyberry3693 3 года назад
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
@abigailkyne7392
@abigailkyne7392 2 года назад
What’s the range?
@vincentwong1127
@vincentwong1127 Год назад
NOW() will be updated every time you open google sheet
@dayallone5995
@dayallone5995 2 года назад
TypeError cannot read property 'source' of undefined at addTimestamp(code 6:24) at onEdite (code 2:3) Plz help me to fix this error
@LP-ig8tg
@LP-ig8tg Год назад
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
@dewaynewest7756
@dewaynewest7756 4 месяца назад
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
@boazksp9513
@boazksp9513 3 года назад
Will you ever make a video about adding authentication to google web app?
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
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.
@jayeshgaad8076
@jayeshgaad8076 2 года назад
how can i get this code?
@customerservice7380
@customerservice7380 3 года назад
Google Forms to Google Groups with custom domain please
@Leover378
@Leover378 3 года назад
Activen la traducción en la configuración de RU-vid Studio.
@ryanloke9517
@ryanloke9517 3 года назад
My app script show: "TypeError: Cannot read property 'source' of undefined. Can someone help me with this?
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
You shouldn't not manually run the code. You run the code by making changes to the spreadsheet.
@abigailkyne7392
@abigailkyne7392 2 года назад
@@ExcelGoogleSheets what does this mean?
@annashshalihcerdas4608
@annashshalihcerdas4608 2 года назад
how to repeat a static task?
@enricoxyz81
@enricoxyz81 2 года назад
my script code don't function why?
@LP-ig8tg
@LP-ig8tg Год назад
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
@dewaynewest7756
@dewaynewest7756 4 месяца назад
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
@jimsoncaliwan9440
@jimsoncaliwan9440 3 года назад
Advance version pls !!!
@gnk0407
@gnk0407 3 года назад
please do advance video
@justbelit
@justbelit 3 года назад
I wish you were a more interactive tutor. There's so many great videos but never any feedback
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
I'm not sure what feedback you need. As a rule, I don't answer open ended questions.
@justbelit
@justbelit 3 года назад
@@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.
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
@@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.
@dewaynewest7756
@dewaynewest7756 4 месяца назад
TypeError: Cannot read properties of undefined (reading 'source')
@dewaynewest7756
@dewaynewest7756 4 месяца назад
Got it
@dewaynewest7756
@dewaynewest7756 4 месяца назад
Got it
@sureshatsasi
@sureshatsasi 3 года назад
Sir whatsapp messages bulk send sricpt post it sir
@sheena6696
@sheena6696 2 года назад
After 2 hours, I gave up
Далее
Google Sheets Multi-Select Dropdowns (Multiple Choice)
14:14
Google Sheets - Calendar Template
31:34
Просмотров 155 тыс.
would you eat this? #shorts
00:13
Просмотров 4,3 млн
İlham Əliyev və Vladimir Putin görüşü başladı
00:17
Google Sheets Form for Data Entry - Apps Script
59:47
Просмотров 349 тыс.
Google Sheets - Search,  QUERY function
22:49
Просмотров 221 тыс.
10 Google Sheets Tips You DON'T Want to Miss
13:51
Просмотров 571 тыс.