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

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.

Thx,
Schmidtric

1 Answer

0vote

polle Points39580

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.

...

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