Concatenates in Smartsheet from Excel?

Georgie

Is it possible to combine multiple cells and add in a symbol, such as |, between two sets of data?

The excel formula being used is: =IFERROR(CONCAT($A7,", ",$B7," | ",$D7),)

Second formula is: =IFERROR(CONCAT($A7,", ",$B7," | ",$D7," | COMPANY"),)

Third is for alt text tags: =IFERROR(CONCAT(SUBSTITUTE($A7," ","-"),"-",SUBSTITUTE($D7," ","-"),"-COMPANY"),)

A = Name, B = Title, D = Location

Thanks in advance!

gorgs

Smartsheet does not have a CONCAT function you simply use the + sign. Example below:

=Name@row + " | " + Title@row