Filter by Blank and Non-Blank Custom Fields

I'd like to be able to filter by Blank and Non-Blank fields so that I can create a dashboard to easily see where data hasn't been entered. This is specifically for a Custom Field I am using, but this could also be for non-Custom Fields. My workaround is to create a report that has this functionality available. Thanks.

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 comments
Avatar
Anastasia

Hi Ian, thanks for posting here! I have some good news: it's actually possible to filter Custom Fields based on whether they're filled in. Here's how:

  1. Open the Filters panel.
  2. In the Custom Fields section, select the field you want to filter.
  3. Choose the "Doesn't have this tag" parameter to view tasks where this field is blank. To see filled in fields, select "Has this tag".

I hope this helps! Let me know if you have any other questions. I'll go ahead and move this post to the the "How To" section, so other Community members could refer to this answer too :)

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

Many thanks Anastasia :-)

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

Folllowing List for Post: Filter by Blank and Non-Blank Custom Fields
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post