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



Formula: IF, AND + Relation,Date props


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.

1 Answer


polle Points82410

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.


nitecrawlergigi commented

Awesome! it worked! thank you so much!


polle commented

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


juwood commented

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


polle commented

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

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!