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).

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
1 комментарий

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!

 

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Using the "OR" operator in a filter
[this list is visible for admins and agents only]

Вверх
Didn’t find what you were looking for? Write new post