3 Replies Latest reply on Oct 9, 2018 9:32 AM by Anastasia Mondy

    Create a filter for keywords in a string text

    Anastasia Mondy

      Please help! I want to be able to create a filter or search that lets me see certain programs depending on the ethnicities they serve using the "target communities by ethnic group" field. I tried an if then else calculation but since the field is a string text of the different ethnicities, projects are only shown for the first statement they match with but then they don't appear for any other statements below that it may match. The page I want the filter to show on is the sheet "Project details". The ethnicity categories are African American, Asian, Native American, Hispanic, Other and Null. I've tried looking up other ways but I get lost when it comes to parameters and putting it in a calculation.