Index & Collect/contains function

Is there a way to collect a date value from another sheet if a certain criteria is met?

To met the criteria I will compare with strings with each other and for that i want to use Contains as the strings are not exactly same, there might be - , or some differences as it will come from user input.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!