Issue combining data of 2 fields

Roland2023

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?

Paul Newcome

It looks like you are using Excel syntax which very often is different from Smartsheet syntax.

Smartsheet does not have a TEXT function. You also combine strings by "adding" them together.

=[Content Subset]@row + [Playlist Brand]@row

If you want a delimiter in between:

=[Content Subset]@row + "delimiter_of_choice" + [Playlist Brand]@row

Paul Newcome

It looks like you are using Excel syntax which very often is different from Smartsheet syntax.

Smartsheet does not have a TEXT function. You also combine strings by "adding" them together.

=[Content Subset]@row + [Playlist Brand]@row

If you want a delimiter in between:

=[Content Subset]@row + "delimiter_of_choice" + [Playlist Brand]@row

Roland2023

Thanks, this resolved my problem!

Paul Newcome

Happy to help. 👍️