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

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.

1 Answer

1vote

polle Points77470

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

Awesome! it worked! thank you so much!

0vote

polle commented

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

0vote

juwood commented

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

0vote

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!

Connect