cross sheet formula with multi-select range?

ive got a database of resources with various teams and departments people are on. in some cases there is multiple teams someone is on. How can i use HAS or CONTAINS with a cross sheet index/match?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!