Question

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

Answer 1

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.

Answer 2

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("")))))