5 Replies Latest reply: Dec 19, 2017 2:57 PM by Mohammed Ahad RSS

    How to have only specifics components of field show on table?

    Mohammed Ahad



      I was wondering if there was a formula to show only specific components of a field? I wish to have a table only show certain specific values from a field, instead of every value available in the field. Please see screenshot below to see what I mean:




      In the table above, what formula can I use for the table to show only "AD-18" and "AD-20" ? I wish to have the table only present those two names in the Campaign Source1 column, WITHOUT having to choose them by clicking. Is there a formula or function to do this? I tried "ValueList" but that is apparently incorrect.


      Thank you in advance for your assistance!