Notion Answers

Get help from Notion experts

Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

2votes

If Formula Question with Dates

Hi

I manage to make a formula so only the date with the selected status is appearing in the calendar.

Unfortunately if I add no status it will show the now() date and most of the items don't have a status and I would like to keep it empty. At the same time it would be great if it woudn't appear on the calendar.

Please have a look at the printscreen:
https://imgur.com/a/Z8iUXas

The Formula I used:

if(prop("Status") == "Plan", prop("Plan"), if(prop("Status") == "Shooting", prop("Shooting"), if(prop("Status") == "Editing", prop("Editing"), now())))

Thank you so much for the help

2 Answers

1vote

polle Points12570

Here is a quick fix using your code as it is.

1- Create a new column duplicating Plan, Shooting or Editing.
2- Rename it to "Nothing".
3- Right click and hide that column.
4- Add an extra line to your formula:

if(prop("Status") == "", prop("Nothing")

5- In the calendar view add a Filter "Where > Status - Is not empty"

I believe that is exactly what you are looking for.

Hope it helps.

1vote

EevaLeena commented

awesome! thank you so much!

0vote

polle commented

You're welcome. If this solved your problem, please select the answer to mark it as solved.

Cheers.

2votes

bensomething Points2360

You can return a blank date by using fromTimestamp(toNumber("")), so the following should work for your formula.

if(prop("Status") == "Plan", prop("Plan"), if(prop("Status") == "Shooting", prop("Shooting"), if(prop("Status") == "Editing", prop("Editing"), fromTimestamp(toNumber("")))))

0vote

nosy commented

Thanks, I'll try this as well.

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