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?