Projects & Tasks

Active/Blank

or(empty(prop("Task Status")), prop("Task Status") == "Active")

or(

If either of the following return true, display ☑️

empty(prop("Task Status")),

Task Status is empty.

prop("Task Status") == "Active")

Task Status is Active

Days Until Scheduled

empty(prop("Scheduled")) ? 0 : dateBetween(prop("Scheduled"), now(), "days")

empty(prop("Scheduled")) ? 0

If Scheduled is empty, display 0

dateBetween(prop("Scheduled"), now(), "days")

Otherwise calculate the number of days between the current date and Scheduled

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>