Using the "OR" operator in a filter
I'm working on a dashboard for my team that will display any task that is missing information, as defined by a few different custom fields.
For example, once a task is created from a request form, it needs to be scoped by our project managers. This involves them filling in a few custom fields. I'd like to create a single widget on a dashboard that checks each of those custom fields for being blank. Ideally, it is using logic similar to this:
IF "priority" OR "stakeholder" OR "due date" = empty THEN (Display that task on the specific widget).
Hi Jared Barden,
Fortunately, you can filter your dashboard items by just selecting the customs fields as a filter item and setting the criteria to "Empty". However, you will need a different widget for each Custom field.
Widget A Widget B Widget C
- Custom A - Custom B - Custom C
If any one of these custom fields is empty, the item will show up in the corresponding Widget (multiple Widgets if multiple custom fields are empty).
Hope this is helpful!