Notion Answers

Get help from other 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

2votes

How can I add a condition to my if statement formula

Hi,

I have tried integrating an Eisenhower matrix into my task list. I have defined urgency with the following formula:

if(dateBetween(now(), prop("Due Date"), "days") < 7, "Urgent", "Not Urgent")

I have another formula that creates a checkbox if the task status is changed to "Done" with the following formula:

equal(prop("Task Status"), "Done")

I want to add a condition to the urgency formula that would leave the cell empty if the task was completed, but I am having trouble writing the correct formula. If someone could help me with writing the correct formula that would be a great help!

Thanks,
Jack

1vote

polle commented

Hey @Jackem!

Please add the solution as an answer below and select it as correct to mark the question as solved.

Glad you found a solution and thank you for sharing.

1 Answer

2votes

Jackem Points410

I found a youtube video that explained if statements very well and came up with the following fix:

if(prop("Complete") == true, "", if(dateBetween(now(), prop("Due Date"), "days") < 7, "Urgent", "Not Urgent"))

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