Sign in to join the conversation:
I was wondering if there is a way to combine 2 columns together when you send an actual email from a row to have everything on one line rather than 2?
Hello,
There currently isn't a way to combine them in the email, you'll want to do this in your sheet.
You can do this by creating a third column, then using a JOIN function to connect the text together with a delimiter (such as a space or dash).
Then when you send the email (or in your automated notifications), include that new column instead of the two separate ones
Details on JOIN.
Details on sending email from Smartsheet.
More information on automated notifications.
Good day @Shaine Greenwood - I used this function as follows but received a INCORRECT ARGUMENT error:
=JOIN([First Name (as per passport)]@row; [Last Name (as per passport)]@row; " ")
Hi @Nats.Rudy
You'll want to use a colon between the two cell references. Try this:
=JOIN([First Name (as per passport)]@row:[Last Name (as per passport)]@row; " ")
Cheers,
Genevieve
Is there a way to add a column that updates with the last comment entered into the conversations from that row? For example: If I entered notes from a call that I had with a client "conversation went well, will follow up" that note would populate into a column on that same row labeled last comment or update. This would…
Good afternoon, Somehow I deleted an entire smart sheet of information. I went into the activity log and I was able to take a snapshot, but now Smartsheet is not letting me import the new information in the smart sheet
Up until yesterday (11/3/25) I was able to click on the top of a column and sort my column. This worked for me yesterday morning but when I went in to work in the afternoon I was not able to sort columns anymore. Also it seems my filters are not working. I am not the admin for this sheet but the admin is saying nothing has…