INVALID DATA TYPE AFTER CONVERTING TO A STRING

Options
lgonzales
lgonzales ✭✭
edited 05/07/24 in Formulas and Functions

I am trying to create a column formula to check if a value exists in another sheet. The value in both sheets consist of numbers and letters, so I assumed I need to convert both columns to a string. Even after referencing the new helper string columns, I am still getting an invalid value. Anyone know how to resolve this? @Paul Newcome - you've been my hero before, you wizard. Any advice?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!