Index Collect not providing exact match



I have a cell that is using index collect, but the value is not the expected one.

I'm trying to find in a list of values the value that contains the sprint number.

However when I'm looking for Sprint 1, I get Sprint 16 or Sprint 17.

I guess when I have Sprint 20, something similar will happen.

Can someone help me on defining how to retrieve the exact match out of an index collect?

Thank you in advance


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!