How to Create a Random Motivational Quote Checklist
Learn how to make a motivational quote checklist in Google Sheets. Watch the tutorial on YouTube now. Enhance your day with inspiring quotes!
How to Create a Random Motivational Quote Checklist
Watch on Youtube: https://www.youtube.com/watch?v=uH3RslDnG_8
Transcript:
(00:00) welcome I want to show you this motivational quote checklist I made every time you check off a motivational quote shows up here a totally random one I'm gonna show you how to create get this quotes page how to get it random it's gonna be really cool so I have formula combination here I'm going to hit delete and we're going to create it from scratch so two things we need first we need the quotes sheet I've already written here a hundred motivational quotes there we go some are fake that are like where'd you identity with
(00:23) layers of resilience or in the breath of light trust the compass of your intuition all different types of very short motivational quotes but we're gonna have them display here in A1 what we want to do first is get a number between one and however many there are here there's a hundred here but we want to do more flexibility so we're gonna do equals Rand between one comma 100 but we can do this much more flexible we can do count a and we're gonna use quotes exclamation point a colon a so now if we
(00:50) add more to this it will automatically add more to this random between all right we need to wrap this next with index because we want to actually index or get a row from this code let's tab so we're gonna do quotes exclamation point a colon a and now our index is referencing the quotes column A we're looking at a row between an 100 that's random at the end here we can add the comma one if we want we have to and now we're going to hit enter and now we have literally text here that is from the
(01:19) quotes page this is a random one and every time we edit anything on this page or check off a checkbox which is in edit it will change so we checked off this one it gives us a random one of the hundreds it's a success stories scripted by meticulous checklist checklist sculptors of efficient Empires with resilience as your armor no challenges in surmountable gives you a little bit of productivity in your day I hope you enjoyed this really quick formula combination if you are a better sheets member and you're watching this on
(01:46) bettersheets.co down below grab this URL and get the sheet thanks so much for watching bye