Question

Looking for a bit of help with an if Notion formula. In my database there are 3 properties - "Start Time" (Time/Date Property), "If Canceled" (Multi-select Property) and "Reminder 1" (Formula Property). I would like to create a formula for the "Reminder 1" property that says:

IF "Start Time" is less than or equal to 24 hours from now

AND

"If Canceled" is "False"

Then show "True"

If only one condition is true or they are both false show "False"

Any Notion help would be much appreciated. Thanks!!

Answer 1

Create a new formula property to count the hours left.

Property Name: Hours Left

Formula:

dateBetween(prop("Start Time"), now(), "hours")

Then use the following Notion formula in your Reminder 1 property.

if(prop("Hours Left") <= 24 and contains(prop("If Canceled"),"False"), "True", "False")

That will work as expected.