Creating a Weekly Planner on Google Sheets: Stay Organized & Productive
Вставка
- Опубліковано 29 вер 2024
- Are you tired of feeling overwhelmed by your weekly schedule?
Watch as I speed through the process of creating a sleek and efficient weekly planner using Google Sheets! This time-lapse video showcases the step-by-step creation of a customizable planner, perfect for anyone looking to streamline their weekly schedule.
Witness the magic unfold as columns for each day of the week are set up, rows for various time slots or activity categories are organized, and tasks, appointments, and events are swiftly added to the planner. With no tutorial or commentary to slow you down, this speed art provides a visual feast of creativity and productivity.
Sit back, relax, and enjoy the mesmerizing transformation of a blank spreadsheet into a functional tool for staying organized and on top of your weekly agenda. Be sure to give this video a thumbs up if you enjoy it, and don't forget to subscribe for more speed art and productivity content! Let's dive into the world of digital planning together! 🚀📅
hi! Thank you for the video. I've finally organized my weekly to-do list in Google Sheets. If you could create a tutorial explaining each step, or at least provide a slowed-down version of the video, that would be great!
Heyy! Thank you for commenting. No problem, i will create a slow downed version of the videos. Will upload it in the week. Stay tuned!! :D
@@Larentiasheetsandplanners Great, thank you, I’ll be waiting!
@@elizavetapudim9677 POSTED!!
how do i do the counter to add up the habits done?
also how do i do the bar counter for weekly tasks?
Hey, Thanks for commenting !!
So you will just use this formula
=COUNTIF(the row/column you want to add up, True )
eg. COUNTIF(B9:M9,True) Then whenever you tick a box it will count it
Hope this Helps, will create a few shorts just showing a few formulae I like to use.
you will first get the % of the weekly tasks that youve completed
then you will use this formula
=SPARKLINE(X, {"charttype", "bar"; "max", 1; "min", 0; "color1", IF(X>0.7, "green", IF(X>=0.5, "yellow", IF(X>0.3, "red", "red")))})
by the X, just put in your the Cell that has that %
eg you have the 20% in cell AO7, then you just replace all the Xs with AO7 then it will look like
=SPARKLINE(AO7, {"charttype", "bar"; "max", 1; "min", 0; "color1", IF(AO7>0.7, "green", IF(AO7>=0.5, "yellow", IF(AO7>0.3, "red", "red")))})
I will also make a short on this formulae and how it works, Hope this helps :D