Taking Cells and then making a note with them

kaerr05

I am very new to Smartsheet and have been looking through all the comments but have not found what I am looking for

In Google Sheets I use a Concatenate formula , that takes what I fill into the cell, I have about 10 different cells that it combines into the note cell, and then it make a note in cell AA for me and I can use that note to send out.

How can I do that in Smartsheets. I have a note cell but what is the Formula to add cell together?

heyjay

JOIN is the equivalent of CONCATENATE or TEXTJOIN.

https://help.smartsheet.com/function/join

Alternatively, you can use plus sign to join strings.

=FirstName@row + " " + LastName@row