In this video I will show you how to create a Goal Tracker Google Sheets template from scratch. I designed this specific layout with the purpose of including as many features as I could. You can totally use it in your daily life or you can just follow the tutorial for fun 😊👩🏻‍💻✨ I hope you like it!

I will talk about:

PART 1:
Checkboxes
Date Pickers
Drop-downs (chip and arrow)
ARRAYFORMULA
Checklist scratching effect (conditional formatting)

PART 2:
SPARKLINE: Progress bar with custom color
COUNTIF and COUNTIFS

PART 3:
Date Formatting
IFERROR
FILTER

00:00 Intro
02:01 Part 1
18:01 Part 2
32:58 Part 3

📌 Get the template here: https://tinyurl.com/32y6e9w8

Please note: The template is sent automatically to your email (don’t forget to check your promotions folder). It should arrive within a few minutes, if it doesn’t please send an email to [email protected]

📌 Check out my ETSY SHOP to purchase ready to use templates:
https://thinklikeagirlboss.etsy.com/

📌 Other Google Sheets Tutorials:
https://thinklikeagirlboss.com/pages/...


#googlesheets #tutorial #productivity #template #goalsetting