Cell contents into Text String

MKTraxel

Hi,

I'm trying to create a column that essentially mail merges within the cell by pulling from previous columns. For example: "[Name] is [Age] and attends [School Name] school." where the bracketed terms are columns in the sheet. Can I do this in Smartsheet or is it restricted to Excel so far?

Thanks!

Andrée Starå

Hi,

Yes, you can. It's relatively easy actually.

Try this.

=Name@row + " is " + Age@row + " and attends " + [School Name]@row + " school "

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting