How to make a Sleep Tracker on Google Sheets (Tutorial +Free Template)
Notedii Notedii
1.54K subscribers
736 views
24

 Published On Premiered Aug 5, 2024

#sleeptracker #googlesheet

In this tutorial, you'll learn how to design a sleep tracker in Google Sheets that helps you monitor your sleep patterns and improve your sleep quality using dropdown menus, color-coded indicators, and charts. You can also create this sleep tracker to sell on Etsy.

I sincerely appreciate you taking the time to watch my video :3

►Video section
►Formula that I used:
=IFNA(SPARKLINE(D5:AE5, {"charttype","line";"color","#d9d2e9";"linewidth",2;"xmin",1;"xmax",28}),)


0:00 : Intro
0:46 : Set up
1:21 : Insert the dates
2:15 : Add a dropdown menu for sleep duration
2:43 : Use color-coded indicators for sleep quality
3:47 : Create a chart to visualize sleep patterns

🌸Here's a free template for a sleep tracker that you may find helpful: https://notedii.com/free-sleep-tracke...
🌸My store: https://notedii.com/
🌸Cửa hàng Notedii cho người Việt - Notedii Vietnam: https://notediivn.com/
🌸My Habit Tracker - Raise your Alpacas :
https://notedii.com/product/ultimate-...


🌸SOCIALS
TikTok:   / notediitiktok  
Instagram:   / notediigram  
Pinterest:   / notedii  

#googlesheets #spreadsheet #sleeptracker #sleepquality #etsyseller #freetemplate #tutorial

show more

Share/Embed