Question

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.

Answer 1

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.