 # Notion Answers

Get help from other Notion users

It's free & easy

### Get answers

Answers, votes & comments

### Vote and select answers

Receive points, vote and give the solution

1vote

# 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

### polle commented Jun 4

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

1vote

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!