I loved your video! It’s extremely helpful and exactly what I’ve been looking for! I was wondering if you knew how to calculate grades with this spreadsheet. That would be so helpful! Thanks!!❤
Hi is there a way to make the days left column in different colours (so if there are say 2 days left it goes red and if there are 3-5 yellow and 5+ green?)
@@AdamPreece-u1g yes! You can use conditional formatting then select less than or equal 2, in between 3-5, greater than 5 , and select your refer colors after each condition! 👍
When I put the total assignment like the code you provided it doesn’t go to the assignment, instead it goes to the courseeee. Please helppp I need it ASAP
Hey, The Range I used for Assignment sheet is started from F12 to F ,. I guess your column must be different with my sheet! just check and change the range of your sheet to your assignment column range! 😅
@@MondayGoalGirl okk so I figured it out but I still had a problem when putting the total assignenet, the completed, and the pending. Whenever I try selecting it, it wouldn't work and I was looking forward to finishing this before next week, so l can put my assignment and be organized before the semester begins. If you are able to, I can share you my sheet and you can look into it if you wouldn't mind (&. THANK YOU AGIAN
@AtsedewerkKebede Hi! try checking the range, you might.have a different range for the checkbox column if you modified the columns. the formula is the same but you will have to change the range according to your specific sheet.
hello what is the fill in color number of the background green and the light tan? Thanks for the video. Maybe in future videos I suggest you slow down actions because it was tricky to follow
I really appreciate your feedback. It's helpful as I'm still learning how to make a good tutorial video! 😊. I just updated color codes in the description. Light Tan: EFE3C1, Light Green: C5D098, Dark Green: 657033, Dark Orange: BF6527.
I loved your video! It’s extremely helpful and exactly what I’ve been looking for!
I was wondering if you knew how to calculate grades with this spreadsheet. That would be so helpful! Thanks!!❤
That's a great idea! I will try to add the grade calculation feature into my next video! 😊
Hi is there a way to make the days left column in different colours (so if there are say 2 days left it goes red and if there are 3-5 yellow and 5+ green?)
@@AdamPreece-u1g yes! You can use conditional formatting then select less than or equal 2, in between 3-5, greater than 5 , and select your refer colors after each condition! 👍
I subscribe thank you hope you’ll share with us more tutorials in google sheets 🙏🏻❤️
Hi, can you help me? I changed the background of my spreadsheet but the gridlines disappear, how can I make them visible?
@@JaneSapdin select View > Show > then select Gridlines 👍
I subscribe! Thank you. I hope you will share more tutorial on google sheets.
Thank you! sure i will 😊 .
when i create a date drop down it doesn't show the calendar as it is showing in yours, i tried it very carefully. ot sure why, please help.
Make sure you’ve selected the entire date range in the cell before creating the dropdown! 😉
When I put the total assignment like the code you provided it doesn’t go to the assignment, instead it goes to the courseeee. Please helppp I need it ASAP
Hey, The Range I used for Assignment sheet is started from F12 to F ,. I guess your column must be different with my sheet! just check and change the range of your sheet to your assignment column range! 😅
@@MondayGoalGirl okk so I figured it out but I still had a problem when putting the total assignenet, the completed, and the pending. Whenever I try selecting it, it wouldn't work and I was looking forward to finishing this before next week, so l can put my assignment and be organized before the semester begins. If you are able to, I can share you my sheet and you can look into it if you wouldn't mind (&. THANK YOU AGIAN
@AtsedewerkKebede Hi! try checking the range, you might.have a different range for the checkbox column if you modified the columns. the formula is the same but you will have to change the range according to your specific sheet.
@@MondayGoalGirl I don't knows anymore I tried everything and I don't want to doo. I might just have to do it from scratch at this point.
hello what is the fill in color number of the background green and the light tan? Thanks for the video. Maybe in future videos I suggest you slow down actions because it was tricky to follow
I really appreciate your feedback. It's helpful as I'm still learning how to make a good tutorial video! 😊.
I just updated color codes in the description. Light Tan: EFE3C1, Light Green: C5D098, Dark Green: 657033, Dark Orange: BF6527.
Cool
❤❤❤❤❤❤
Voice reveal 😮
🤣
should not charge for this
@@billgyrotech I put hard work into this tutorial and it’s FREE already! If you don’t have time to do it yourself plz respect my time and effort! 👍