Contains/Has with Dropdowns

Im using a Sum(Collect(..)) formula that collects data from a dropdown list(Roof, Ground and Canopy) using a dropdown list (Roof, Ground and Canopy), but it only collects it if the dropdown from the criteria has all values in the search range.

Is there a formula that it can collect if it contains any of the values from the search range? I.E. criteria is Roof and Ground (as a drop down value) and search range has only Roof (also as a drop down value).

I want that value to also be collected.



  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭

    Two potential options, split your formula into two parts, or use an OR function. If you could share your current formula, we might could quickly help in any adjustment that might help you.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!