How to Make a Dynamic Formula for Multiple Searchable Values Using CONTAINS or HAS?

This discussion was created from comments split from: Contains formula not picking up text.

Answers

  • Paul Newcome
    Paul Newcome Community Champion

    Are you able to provide screenshots for context?

  • Georgie
    Georgie Employee

    Hi @MHumphrey,

    If you haven’t already, take a look at the following resources for more information on the HAS and CONTAINS functions:

    HAS is designed to work with multi-select contact list columns and multi-select dropdown columns, whereas CONTAINS won’t work with these. 

    What happens when you try the different options you provided of HAS or CONTAINS in your formula? If you could provide some examples of the formulas you’ve tried and the results/error messages you’re seeing, that should help us to determine what’s not quite right in the formula. 

    It would also be really helpful if you can provide screenshots showing how your sheets are set up, so that we can understand the ranges and exactly what you want to achieve with the formula - could you either provide screenshots of the existing sheets (with any sensitive data hidden), or create some test sheets and provide screenshots of those?

    Thanks,

    Georgie

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!