Help between Notion users

It's free & easy

### Vote and select answers

Receive points, vote and give the solution

1vote

# Formula: IF, AND + Relation,Date props

Hi,

I have a DB like this:

"Name" | Person: "Owner" | Date: "Answer Date" | Formula: "Status"

I'd like to obtain a status formula based on the following criteria:

• If "Owner" is empty, return "To be assigned"
• If "Owner" is not empty and "Answer Date" is empty, return "Pending"
• If "Owner" is not empty and "Anwer Date" is not empty, return "Answered"
Others: "Check"

I've been playing around with these:

``if(prop("Owner")=="" and prop("Answer Date"), fromTimestamp(toNumber("")=="")``

However, I'm not very familiar with programming, only Excel user.

Any help will be very appreciated. Thank you.

1vote

polle Points79040

This Notion formula will work as you need.

``if(empty(prop("Owner")), "To be assigned", if(not empty(prop("Owner")) and empty(prop("Date")), "Pending", if(not empty(prop("Owner")) and not empty(prop("Date")), "Answered", "Check")))``

Hope that helps.

1vote

### nitecrawlergigi commented Apr 24, 2023

Awesome! it worked! thank you so much!

0vote

### polle commented Apr 25, 2023

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

0vote

### juwood commented May 22, 2023

Why doesn't `prop("Owner")==""` work? How does Notion interpret an empty field? As a zero?

0vote

### polle commented May 23, 2023

See my answer above, you need `if(empty(prop("Owner"))` for that.

### Extend Notion Powers

...

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!