Can't compare two string values

Joseph Pardo
Joseph Pardo ✭✭✭
edited 03/15/23 in Formulas and Functions

So I'm using this formula to try and compare two "String" values. In this situation, some values in Column 2/3 will be numerical only and some will have text. I have a helper column checking that both are string values but it still won't match. I've tried with collect and contains too.

I'm trying to pull the value in column2 of Grid 1 onto Grid 2. Any help would be appreciated.

=INDEX({Grid 1 | Column 2}, MATCH([Column2]@row + "", {Grid 1 | Column3}))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!