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

Question

1vote

Ifs Formula Help

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!!

1 Answer

0vote

polle Points79930

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.

0vote

adrog commented

Genius. Thanks so much!

0vote

polle commented

Glad to help. Please select the answer to mark the question as solved.

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!

Connect