Notion Answers

Help between Notion users

Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution



Notion Formula to randomly check as true every hour

I am doing some tests with a formula. I have 3 columns.

Name - Number - Formula

The name is whatever, the number is from 0 to 10 and the formula is:

(toNumber(formatDate(now(), "DDDD")) + year(now()) * 365) % 10 == prop("Number")

That formula checks (mark as true) a different item from the list each day in the Formula column.

I need to do it by hours. For example every 3 hours or every 6 hours mark a different item from the list as true. Just 1.

Anyone knows how to create that Notion Formula?

Thank you.

Please log in or register to answer this question.


Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!