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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!