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.
Help Article Resources
Check out the Formula Handbook template!