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