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
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
