Weird behavior with MATCH


I'm trying to build a scoring system but i've got some strange behavior from MATCH.

What i finally did was putting all items in one new grid , the formula in another and this is what i've got?

Formula under Strategic fit : =MATCH([Strategic fit]@row, {New Sheet Range 1})

Formula under priorities : =LEN([Strategic fit]@row) (just to see if the length was an issue)

Any thoughts?

First screenshot are the results, the second the sheet with the data (New Sheet Range 1)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!