Simple To Do List Template with built in Calendar
Learn how to create a simple to-do list template with a built-in calendar in Google Sheets, featuring priority statuses and date validation for effective task management.
we're making a really simple to-do list template with a bit of priority statuses drop- down menus dates and the really cool part about this is we are going to create a calendar at the very top...
somebody's going to write something else here like March or some other thing we actually don't want that let's go rightclick and view more sell actions data validation over here on the right we're going to add a rule...
our family picnic is on Saturday as well so we have these dates maybe we want to also see what day of the week this is so we'll say day...
solo all the solo events that are just me I'm going to put in blue all the family ones I'm going to put in green done and actually want to change that to E5 colon e Click done...
want to see this all in a calendar up here we want to know anything that we put in our list down here even if it's next week two weeks from now what is on our calendar this week...
yes they're yoga and laundry so we need to edit this and we need to go join and our delimiter is a quote plus a command enter plus a quote and there that will join each of these items in here anytime we have uh something there...
we can say we're going to do that on Sunday and right away it's in our calendar up here we can set this to a low priority solo yes so every Sunday we can review our calendar...
now to get more tips tricks how-tos get more out of your Google Sheets than you ever have before I'm excited to be making a ton more videos here ask me questions down in the comments and I will answer them in future videos...