That was so good! I never use sheets but I travel a lot and that was so easy to follow. One strange thing, my F2 formula: =COUNTIFS(F4:F40,TRUE,H4:H40,"")/COUNTIF(H4:40,"") was causing the % to move up really slowly, like 1% per tick. Of course since I'm a sheets noob I couldn't figure out how to fix it so I ran it through Gemini Advanced which gave me the following formula instead: (SUMPRODUCT((F4:F40=TRUE)*(G4:G40""))/COUNTIF(G4:G40,"") No idea what the difference is but this one worked. Anyway, thank you.
Hi! The issue with your formula is you were missing an H right before the last 40. H4:40 should have been H4:H40 This is what your formula should end up looking like: =COUNTIFS(F4:F40,TRUE,H4:H40,"")/COUNTIF(H4:H40,"") I hope this helps! 😊👩🏻💻✨
learned so much in this video thank you! I just had a question. If I were to later expand or add new rows to my tables, will I need to update the formulas?
Thanks a lot for your project based tutorials . my take would be for you to complete the project and populate the spread sheet with real life data (it could be fictitious), so that we would know exactly how the template works and how to use the template
Thanks a lot, always interesting video and like every time I discover something new that can help me in my work. And also in my spare time. So thanks again. And if by chance you pass through Italy, it will be a pleasure to offer you a delicious pizza and a coffee at the end of the meal. Yes, after all, stereotypes about Italians are sometimes true, not so exaggerated, but true. 🙂
Amazing video, thank you! 🤩🤩 Can you make tutorial how to create a weekly spreadsheet with automatic date change? It doesn't look good when you have to include 52 weeks in a spreadsheet. I really would love to know how you make it! I mean something like in your previous video - ua-cam.com/video/ZzWMfZgRSbs/v-deo.html&ab_channel=thinklikeagirlboss
Thank you for this. Could you create a tutorial for making an automated shopping list? Thank you
Followed step by step and created this for a Lake Powell trip. Love the progress bars and the ease it creates when packing. Thank you so much!
Is there a way to save as a template?
I absolutely love this and it was so easy!
Thank you so much for watching!! I'm so happy you liked it! 😊👩💻✨
Thank you so much, i can't wait to build this myself
Please let me know how it goes! 😊👩💻✨
That was so good! I never use sheets but I travel a lot and that was so easy to follow. One strange thing, my F2 formula:
=COUNTIFS(F4:F40,TRUE,H4:H40,"")/COUNTIF(H4:40,"")
was causing the % to move up really slowly, like 1% per tick. Of course since I'm a sheets noob I couldn't figure out how to fix it so I ran it through Gemini Advanced which gave me the following formula instead:
(SUMPRODUCT((F4:F40=TRUE)*(G4:G40""))/COUNTIF(G4:G40,"")
No idea what the difference is but this one worked. Anyway, thank you.
Hi! The issue with your formula is you were missing an H right before the last 40.
H4:40 should have been H4:H40
This is what your formula should end up looking like:
=COUNTIFS(F4:F40,TRUE,H4:H40,"")/COUNTIF(H4:H40,"")
I hope this helps! 😊👩🏻💻✨
@@thinklikeagirlboss Ah gotcha! Very helpful, thank you for replying. You have a good eye for detail.
Very easy tutorial. Thank you very much!
Thank you so much for watching!! 😊👩🏻💻✨
learned so much in this video thank you! I just had a question. If I were to later expand or add new rows to my tables, will I need to update the formulas?
amazing stuff! thank you for posting this tutorial
Thank you so much!! I hope you find it useful 😊👩💻✨
thank you so much!!
Thank you for watching! 😊👩💻✨
Thank you so much 🥰
Thank you for watching!! 😊👩🏻💻✨
Thanks a lot for your project based tutorials . my take would be for you to complete the project and populate the spread sheet with real life data (it could be fictitious), so that we would know exactly how the template works and how to use the template
Thank you for your input! 👩🏻💻✨
Thanks a lot, always interesting video and like every time I discover something new that can help me in my work.
And also in my spare time.
So thanks again.
And if by chance you pass through Italy, it will be a pleasure to offer you a delicious pizza and a coffee at the end of the meal.
Yes, after all, stereotypes about Italians are sometimes true, not so exaggerated, but true. 🙂
That's so sweet of you!! Thank you so much!! Pizza and coffee are some of my favorite things eveeeer 😊👩💻✨
❤ Thank you sis.Your video tutorials are very helpful while making any document...😊🫂✨️🌸🙃👍
I'm so happy you like them! Thank you for watching! 😊👩🏻💻✨
Amazing video, thank you! 🤩🤩 Can you make tutorial how to create a weekly spreadsheet with automatic date change? It doesn't look good when you have to include 52 weeks in a spreadsheet. I really would love to know how you make it! I mean something like in your previous video - ua-cam.com/video/ZzWMfZgRSbs/v-deo.html&ab_channel=thinklikeagirlboss