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



Hello All,

I am new here and to notion, so apologies if is a silly question.

I am building an actions tracker and need 3 dates:

  • Raised On
  • Due On
  • Closed On

then I have a status = In Progress, Delayed, Closed

I want to create a formula to handle the following:

If Close On is empty and Due On is less or equal to now(), then status = In Progress
If Close On is empty and Due On is more then now(), then status = Delay

Tried to create the following:

if (prop("Closed On") == "", if ( prop("Due On") <= now(), "In Progress","Delayed"))

For sure doesn't work :(

Any help is welcome.


1 Answer


polle Points35780

Try this Notion formula.

if(prop("Closed On") == "" and prop("Due On") <= now(), "In Progress", if(prop("Closed On") == "" and prop("Due On") >= now(), "Delay", "Nothing"))

Hope that helps.

Please log in or register to answer this question.

Exclusive for Notion Answers Users


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!