An Assignment Tracker You’ll Actually Use | Google Sheets & Forms

Do you have trouble keeping up with your assignments or To Do’s? In this video, create an assignment tracker using Google Sheets and easily input them on your mobile device with a Google Form. You'll create a Google Form to input all your required info, including assignment, class, difficulty rating, due date, and space for notes. Then we’ll move on to customizing a Google Sheet to use dropdowns, smart chips, and formulas. We’ll also add custom formulas to apply conditional formatting to mark an assignment as completed and add icons to identify upcoming due dates! Finally, we’ll “appify” the form, adding an icon to your iPhone’s home screen so you can enter your assignments with ease! Host: Jess Stratton #GoogleSheets #GoogleForms #Productivity #Student #Google ⌚ TIMESTAMPS 00:00 - Intro 00:14 - Create a Google form to capture your input 02:26 - Link the form responses to a Google Sheet 02:55 - Publish and fill out your form 04:16 - Open the newly created responses sheet 04:26 - A warning about editing form data directly 05:18 - Hide columns and add dropdowns and smart chips 07:07 - Add a “Done” checkbox column to the table 07:36 - Add conditional formatting to a column to mark an assignment as completed 09:50 - Add a “Due Soon” visual indicator for assignments due in the next 7 days 11:50 - Access the form on an iPhone and create an app shortcut 13:30 - Conclusion 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter 🔽 CONNECT WITH ME - Official website: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🎁 TOOLS AND DISCOUNTS ✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY ✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM ✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL ✅ 📹 CapCut | https://bit.ly/installcapcut ✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa ✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax ✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry ✅ 💵 Quickbooks Online | https://bit.ly/intuitquickbooksonline ✅ 👥 Hubspot | https://hubspot.sjv.io/DKo6jb ✅ 📈 Semrush | https://bit.ly/semrush14dayfreetrial ✅ 🎥 Descript | https://get.descript.com/sf22jb63w2tx ✅ 🏓 Smartsheet | https://bit.ly/trysmartsheet 🎒 MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz ⚖ DISCLOSURE Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same. #stratvert