Відео

docs.google.com/spreadsheets/d/1goDjJCN3tCAVityM_f5CkjGHpr6LoKxSgr3Fp2amByw/edit?usp=sharing

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!!

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