๐Ÿ”ฃ Show a Random Quote Each Day Of The Year | template

Alex Sherwood
Oct 6 '19 ยท 2 min read ยท 717 views
๐Ÿ‘‹
A couple of people in the Notion Made Simple community have asked for a way to sort a list at random, to display a random quote for example. As far as I know, Notion doesn't have a formula function that enables you to create a completely random number. But since time's always changing, I thought I'd get creative using date formulas. This isn't quite random, you'll need to reassign a day of the year to your quotes each year. But hopefully that's an acceptable compromise or maybe you'll have forgotten the order of the quotes after 365 days! Let me know if you have any questions here.
Contents

๐Ÿ“– Guide

Start by creating a list of days of the year in a random order. The easiest way to do this is by using the RAND() function in Excel or Google Sheets.
I've set up a spreadsheet for you to use here:
The 'random numbers' column will be populated with a new sequence of random numbers each time you load the sheet so there's no need to worry about making any edits.
If you're using this for the first time, you can skip step 1 as the days in year are already randomly sorted.
  1. Either copy the sheet to your Google Drive and sort it there or select cells B2:C67, starting with cell C2. Then go to Data > Sort range by column C, A โ†’ Z.
  2. Copy the days in year onto your clipboard. I've found that Notion doesn't like it if you copy 365 days worth of cells and past them into the 'Quotes (change each day)' table so you might have to copy and paste 182 days at a time.
  3. Select the first cell in the Quote no. column, then press escape to highlight the cell, then paste using ctrl + v or cmd + v.
๐ŸŽ‰ Your quote have now been assigned a random day of the year. When the day of the year matches the day from today's date, that quote will be displayed in your linked database.
I created this guide on day 279 of the year so if you're looking at this a couple of days later, the table in Today's quote will be empty.

Quotes master table

Quotes (change each day)

QuoteQuote no.Day of yearShow quote
"Life begins at the edge of your comfort zone"278  
"The definition of insanity is repeating the same actions over and over again and expecting different results."279  
"If I had asked people what they wanted, they would have said faster horses."280  

Today's quote

Quotes (change each day)

Quote
"Life begins at the edge of your comfort zone"
"The definition of insanity is repeating the same actions over and over again and expecting different results."
"If I had asked people what they wanted, they would have said faster horses."

Formulas

Day of year formula

formatDate(now(), "DDD")
This retrieves the day of the year in a sequence from 0 - 365 from today's date.

Show quote formula

prop("Quote no.") == toNumber(prop("Day of year"))
This compares the Quote no. to the Day of year to see if they're the same. The toNumber function converts what Notion still thinks is a date, into a number so that the formula can compare it to the figure in the Quote no. property.

If you're still learning to use Notion, I'd highly recommend checking out Francesco D'Alessio's courses -
(this is an affiliate link, I'll receive 30% of fees that you pay for if you sign up after using this link)
Updating...

Share on