Issue combining data of 2 fields


I need to combine data of two fields. 1 field is a dropdown and the other open text.

The first option to combine them didn't work:

=TEXT([Content Subset]@row, "General") & [Playlist Brand]@row

The second option was to convert the 'Content Subset' to text and then combine, but that again didn't work:

=TEXT([Content Subset]@row, "General") & [Playlist Brand]@row

Also separating the steps, converting the 'Content Subset' to text on its own, didn't work. I'm not sure what other options are there, or what may cause this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!