How to use Collect & Contains function to pull value from different sheet?

edited 07/18/22 in Formulas and Functions

I cannot use Index(Collect) because i am comparing the strings as criteria and it doesn't have to be exactly same, even if a word is match, I want my formula to execute.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!