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.
- 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.
- 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.
- Select the first cell in the Quote no. column, then press escape to highlight the cell, then paste using
ctrl + vor
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)
|Quote||Quote no.||Day of year||Show 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|
Quotes (change each day)
|"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."|
Day of year formula
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
toNumberfunction 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)