No video

How to Build Simple To-Do-List Using Google Sheets🤓📅

In this video, you will learn how to create a simple AND practical To Do List on Google Sheets. We will learn about different G-Sheets functionalities as we build the list, such as creating drop-down menus, conditional formatting and much more!🤩
If you like this video, please give it a thumbs up 👍 and subscribe to get notified of future videos! 🔔
Let me know in the comments section below what other tools you use to track your tasks⬇️

Пікірлер: 56

  • @dciofficialchannel
    @dciofficialchannel46 минут бұрын

    Nice mam

  • @barbaraeverett1908
    @barbaraeverett1908 Жыл бұрын

    This was very helpful and easy to follow! Thank you so much!!!

  • @michatuptus2063
    @michatuptus2063 Жыл бұрын

    Dziękuję bardzo! Good teaching!

  • @abdelrahmanghoweba4167
    @abdelrahmanghoweba41672 жыл бұрын

    I love it, thanks for explaining.. Life made easier!

  • @charanteja875
    @charanteja875 Жыл бұрын

    Thank you so much for the video...I've been searching for this video for a long-long time. Really Helpful.

  • @pierreepohmoudio7609
    @pierreepohmoudio760920 күн бұрын

    Nice

  • @sb6782
    @sb67822 жыл бұрын

    thanks for the video

  • @emmaleeconstant-libertad3725
    @emmaleeconstant-libertad3725 Жыл бұрын

    Very clear!!! Thank you so much

  • @okaiteyeemmanuel7788
    @okaiteyeemmanuel7788Ай бұрын

    The video is straight to the point. Thank you for the video

  • @najeebimran5085
    @najeebimran5085 Жыл бұрын

    Thank you Helpful video and clear explanation.

  • @absumon93
    @absumon932 жыл бұрын

    Absolutely helpful video ever.

  • @melisaannibaffa678
    @melisaannibaffa6782 ай бұрын

    Thank you. Great teacher.

  • @katherinepage4003
    @katherinepage4003 Жыл бұрын

    ❤️😍😍 Millones de gracias!

  • @judithanthony
    @judithanthony Жыл бұрын

    thank you this was super helpful!!

  • @dewiyullly
    @dewiyullly2 жыл бұрын

    thankyou so much, love from bali

  • @anatzamberg7471
    @anatzamberg74712 жыл бұрын

    Thank you!

  • @omowunmiadewale9810
    @omowunmiadewale9810 Жыл бұрын

    Thank you so much💞

  • @ssjshivam
    @ssjshivam Жыл бұрын

    Thank you so much , I learnt something new ^_^

  • @liamartinez2940
    @liamartinez29402 жыл бұрын

    Thank you!!

  • @gowebsite
    @gowebsite2 жыл бұрын

    excellent, many thanks

  • @th3.mik3
    @th3.mik3 Жыл бұрын

    Thanks for this video, it makes me to the next step... Cheer🤩

  • @pj04laus
    @pj04laus Жыл бұрын

    Thank You!

  • @mahammedshafiq7869
    @mahammedshafiq78692 жыл бұрын

    Hi thank you for the explanation

  • @wishfullayers2907
    @wishfullayers2907 Жыл бұрын

    perfect thank you

  • @MamiFher
    @MamiFher2 ай бұрын

    I learned a lot! more videos to come

  • @liamartinez2940
    @liamartinez29402 жыл бұрын

    This video was great!!!

  • @ishansingh2962
    @ishansingh2962 Жыл бұрын

    Thank you so much ❤️

  • @janglefant
    @janglefant Жыл бұрын

    nice step by step video :)

  • @noureddine309
    @noureddine309 Жыл бұрын

    Thanks a lot ❤

  • @41-siddharthabehera6
    @41-siddharthabehera6 Жыл бұрын

    Amazing video

  • @wolfmaja7116
    @wolfmaja7116 Жыл бұрын

    Gracias

  • @scottmudrauskas8347
    @scottmudrauskas8347Ай бұрын

    thank for your tutorial, I was able to follow your instructions and I created an awesome to-do list. Can you add documents to the list?

  • @igcsetube9289

    @igcsetube9289

    28 күн бұрын

    @@scottmudrauskas8347 Glad you found this helpful! Yes, you can link G-drive documents in any cell! Copy the link of the document, then via the ribbon go to Insert>🔗Link. Hope this answers your question.

  • @damonicwilliams6396
    @damonicwilliams63965 ай бұрын

    Awsome video

  • @bestexcel2030
    @bestexcel2030 Жыл бұрын

    good

  • @jeremyorwhatever
    @jeremyorwhatever Жыл бұрын

    This is great! My view looks slightly different - my dropdowns have gray bubbles which are ugly and busy looking. They also make it harder to see the conditional formatting. Do you know how to replicate this and how to remove the bubbles?

  • @jeremyorwhatever

    @jeremyorwhatever

    Жыл бұрын

    Found the answer already. Under Data Validation > Advanced Options > Display Style > don't use "Chip"!

  • @igcsetube9289

    @igcsetube9289

    Жыл бұрын

    Yes, there has been updates to G-Sheets since I recorded the video! Thank you for letting us know how to switch the style!💯

  • @tyeisheaconner7776
    @tyeisheaconner7776 Жыл бұрын

    Thank you for sharing I am so grateful I am learning how to become an entrepreneur and your video was definitely beginner friendly and had a tone of information Can you create the list on your cell phone or do you have to create the list on an computer and iPad Also will you be able to access the to do list on your phone in the Google drive

  • @igcsetube9289

    @igcsetube9289

    Жыл бұрын

    Hi Tyeishea, I'm very glad you found this video helpful! And kudos to you for upskilling yourself as you embark on your entrepreneurial journey👏 You can both access and edit the list via your phone although you might find it not to be as user-friendly as via your pc/laptop. You can also download the Google Sheets app instead of accessing your list via the Drive.

  • @tyeisheaconner7776

    @tyeisheaconner7776

    Жыл бұрын

    Thank you again for responding

  • @khalidbaacha
    @khalidbaacha Жыл бұрын

    10/10

  • @rajupatil9643
    @rajupatil9643 Жыл бұрын

    Thanks for the video helped me a lot. Is there a way to move the completed tasks at the bottom or other sheet?

  • @igcsetube9289

    @igcsetube9289

    Жыл бұрын

    Thanks, glad you found it useful! You can use the 'Filter' function to hide the Completed tasks.

  • @annamalai7635
    @annamalai7635 Жыл бұрын

    Thanks for your support 🙂🙂🙂🙂

  • @ayouyang1
    @ayouyang12 жыл бұрын

    Hi, is there a way for the entire row to change color and not just one specific cell? Thanks!

  • @igcsetube9289

    @igcsetube9289

    2 жыл бұрын

    Hello Anna, this is a very good question! Yes, you can! I will try to upload a video soon to cover how this is done, but meanwhile please follow the simple steps I outlined below (the cells referenced are based on the sheet I created in the video): 1) Highlight column E and then from the top ribbon click on Format>Conditional Formatting and delete all rules applied on column E to start fresh 2) Go to cell E2, and then from the top ribbon click on Format>Conditional Formatting>+Add another rule 3) In the "Apply to range" field, type "A2:G2" so that the entire row is highlighted when the rule is applied 4) Under "Format rules," select "Custom formula is" from the drop-down menu 5) Under "Format rules," in the "Value or formula" field, type =$E2="Completed" The $ sign is used to signal to Google Sheets that the focus is on what changes in the cells in column E 6) Under "Formatting Style," select the "Fill color" as green 7) Click on "Done" 8) Right click on cell E2 and select Copy 9) Highlight all cells below E2 in column E, and then right click and select Paste special>Conditional formatting only 10) Repeat all steps above for "Not started", "In progress" and "Delayed" using grey, yellow and red colors. Let me know if this works!🤩

  • @saicharangoud8027
    @saicharangoud8027 Жыл бұрын

    If anyone created the Google Sheets same as it in video... Please Share the link... So that I can make a copy of It and use it. Thank You

  • @jorgenolsson4612
    @jorgenolsson4612 Жыл бұрын

    I added a new task, but when the task description was floating, it didn't wrap it. I thought I have done it for all columns before (like you did). Do I need to do it again?

  • @igcsetube9289

    @igcsetube9289

    Жыл бұрын

    Hi Jorgen, thank you for your comment. Yes, it should work for all the columns you applied the wrapping to. Perhaps try again and see if it works this time or not.

  • @mahammedshafiq7869
    @mahammedshafiq78692 жыл бұрын

    I also want ti add one more thing that once the tadk is completted i want it to move to the last. Can you help on that pls

  • @igcsetube9289

    @igcsetube9289

    2 жыл бұрын

    Hello, thank you for watching the tutorial and for your comment. You can use the Filter function to view only for e.g. 'Not started', 'In progress' and 'Delayed' tasks, and hide 'Completed' tasks. Hope this helps.

  • @raindropsofsky
    @raindropsofsky Жыл бұрын

    Google sheets and excel are not complicated to be understood.

  • @subs4794
    @subs4794 Жыл бұрын

    Audio is WAY too low.

  • @igcsetube9289

    @igcsetube9289

    Жыл бұрын

    Yes, the volume is a bit low in this video. I will make sure it's better in the next video, thanks!

  • @dkeillar
    @dkeillar Жыл бұрын

    Thank you!