Community

Welcome 🖖

Hi there! 🙂 Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome 🖖 Have you checked out this week's Release Notes yet?

Hey! 👋 Curious about something? Visit How To to search and ask the Community for answers.

Welcome! 👋 Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.

What can we help you with?

e.g. Gantt chart, Creating tasks, Sharing folders...

Filtering by Custom Column Values- AND/OR logic

26 comments

  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Anna G

    Hi Sarah, thanks for posting this on the Community! Our Product Team is currently discussing possible ways to improve the Dashboard functionality, and your feedback is definitely helpful.

    While at the moment it’s not possible to create a Dashboard widget that would include tasks with 2 different values of the Custom Field, it’s possible to achieve that using Reports. Please note that it will work only for dropdown-type Custom Fields.

    Here’s how you can do it:

    1. Click “Reports” at the top of the Workspace and select “New Report From Scratch”.
    2. Choose “Tasks” on the first step of the Report Builder.
    3. Select Folders and Projects you would like to include data from.
    4. The third step allows you to apply filters. Click “Add more filters” if you don’t see the Custom Field you want to use for filtering tasks and select the necessary values of the Custom Field (in your example you’d choose “CAC” and “FCT”).
    5. Choose the “Table” layout and click “Save and View”.

    The Report will show you tasks with values “CAC” or “FCT”:

    Do you think it could work for you? Let me know if you have any questions about it, I’m always happy to help!

    Anna G Community Team at Wrike 🌎Discover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Bob Kapheim

    Hey!  I'd like to second the request for Boolean Operators when creating a dashboard.  I thought it would be simply to have a widget of tasks assigned to both UserA and UserB, But, instead I get all tasks assigned to UserA and all tasks assigned to UserB.

    Is this helpful? 4
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Holly Tomkins

    I'd love to have options for and/or logic in the forms, similar to matching all or matching any criteria.

     

    I have forms that I would like to view custom fields (dates) by last week, this week, etc. But I want it to bring back results that match any criteria.

    (i.e. if Job A has delivery date 1 as this week, but Job B has delivery 2 date this week, and Job C has delivery 3 date this week)

     

    I was to see all those delivery dates in one view regardless of when the other delivery dates are. If any hits this week I want to see it in one report.

     

    +1!!

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Prentiss Adams

    Filters on lists and grids don't allow operators either.  These would also be nice to have.

    Is this helpful? 2
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Paul Copping

    Definite votes for AND/OR logic to be added to filters on reports.

     

    Is this helpful? 4
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Stephanie Westbrook

    (Edited )

    @Prentiss I just want to clarify quickly to make sure I understand. Would you like to see and/or functionality when filtering for Custom Fields in the List and Table Views?

    Stephanie Westbrook Community Team at Wrike 🌎Discover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 2
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Prentiss Adams

    Yes!  And not to pile on, but it would also be nice if the List and Table Views used the Date drop down for filtering rather than the string drop down.  In list and table views, when filtering on custom date fields you can't choose a range of dates.

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Stephen

    Hi Prentiss, thanks for the clarifying Stephanie's question. For your other suggestion about date ranges for Custom Fields, I really like this idea and would recommend posting as a stand alone Feedback post with more detail so members can upvote and discuss the idea. 
     
    Also, you're never piling on! This is the right place to share your feedback and we really appreciate it 🙂
    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Romain Maurer

    +1 on the OR/AND logic in dashboard AND in the search bar please. (if you have to do one before the other, dashboard definitely first!)

    We are (about to be) using the professional version of Wrike and therefore have no access to reports so this is a really mandatory feature for us that will actually decide whether we are going all-in with Wrike or not. At least knowing that it's being developed would be good.

    Regards,

    Romain

    Is this helpful? 3
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Christine Bromley

    We really need the AND/OR Logics built in for Dashboards, Reports, and Calendar features.  It is real discouraging missing feature with new team in Wrike (+250 users).  Is there a timeline for adding this feature?

    Is this helpful? 2
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Robert Armič

    Our dashboard are becoming quite cluttered with increasing usage of custom attributes. We are forced to make many seperate dashboards, with AND/OR filtering conditions we could combine them.

    This filtering overhaul should of course be across the board, for example the Edit functionality in Dashboards does not cover all functionality, also advanced filters like "notin" should be available like any other filter not hidden inside search field.

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Alexia Alford

    We really need the and/or logic built in the Dashboard widget "Add more filters" - to best utilize the custom "Fields" we have in place. 

    My team members need to build their own dashboards including custom fields to best see their workloads. 

    thanks!

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Antonio Jose

    It´s really importante to have this feature, is in the pipeline??

     

    Thks

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Kevin Karl

    (Edited )

    +1 Vote for an AND/OR option to be added in Dashboard widgets! Would be great for our users to be able to track projects they have either been assigned to or submitted for execution in 1 "My Projects" Widget on their dashboard, rather than having to have 2 separate widgets for projects they've been assigned to & another for ones they've authored.

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    George Colonna

    Would like to make a report that allows me to search on custom "build number" where I can use a comma delimiter to query multiple build numbers in one report.

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Lisa

    Hey @All, thank you for adding your comments and upvoting the suggestion, it really helps our Product team assessing popularity and possibility of the feature. I don't have an update to share, but I'll get back to you if/when I have news. 

    Lisa Community Team at Wrike 🌎Discover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 3
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Juhyun Kim

    Really need this feature. 'OR' function!

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Andreas Diening

    Yes! Boolean logic for filters in all views would be SUPER helpful!

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Diana Gonsalves

    HI Lisa,

    Any updates on this?

    Thanks

    Diana

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Marko Heikinheimo

    In addition to AND/OR also NOT of course needs to be amongst the operators in order to make filtering, reports etc flexible enough.😅

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Hugh

    Hey everyone, apologies for the delay in response here. 

    The Product team is interested in implementing this suggestion into Wrike, but it is currently not on the short-term roadmap. Once I have further information about this, I'll be sure to let you know here 👍

    Hugh Community Team at Wrike 🌎Discover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Saad Fahim

    Need this feature. Boolean logic is there on most apps for filters. Basic requirement 

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Andreas Diening

    (Edited )

    I agree this is a super important feature that is missing!

    It is really unfortunate that this is not getting a higher priority...

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Hugh

    Hey everyone, thank you for your feedback here! It's been passed on to the Product team.

    Hugh Community Team at Wrike 🌎Discover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Darrin Laudenbach

    +1 that this would be a very helpful feature.  Incomplete filtering options clutters and limits the usefulness of the dashboards.  

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Hugh

    Welcome to the Community, Darrin Laudenbach!

    Thank you for sharing your input here. If you need anything else, be sure to let me know.

    Hugh Community Team at Wrike 🌎Discover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
    Comment actions Permalink

Please sign in to leave a comment.

Folllowing List for Post: Filtering by Custom Column Values- AND/OR logic
[this list is visible for admins and agents only]

Community

Welcome 🖖

Hi there! 🙂 Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome 🖖 Have you checked out this week's Release Notes yet?

Hey! 👋 Curious about something? Visit How To to search and ask the Community for answers.

Welcome! 👋 Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.