Sign in to join the conversation:
I would like to have more than one person in the send to column for each row. I have seen this done before and I am just not sure on how to do this.
Please assist.
Thank You
Hi Justin, if you are using a contact column type, you will not be able to add more than one contact. There are rumors that this is being worked on by smartsheets but at this current time, no.
We circumvent this by creating additional Contact columns in the sheet. We can then set up notifications to send to both columns in the sheet.
Thank you Very Much for the information.
Also is there a way to put a permanent email address in a column if that is the email you want it to be sent to every time
How is data being added to the sheet? Are you using a form?
I am using the actual sheet or a form depending on how someone wants to do this.
The challenge with the actual sheet itself is that you can't have a formula in a contact column type. If you were submitting the data via a form you could have a contact field "filled" with default data and hidden from the user so that their email automatically populated it. If you're using the actual sheet, it will have to be manually filled. You could create a notification on a new row entry or an automated update request when the email column is blank and a new row has been added that could be sent out requesting the field be populated, just in case someone forgot to populate it manually.
I am trying to get the form that is already filled out by someone to be in the actual email rather than have someone click on update form. Would I have to do this by doing a screenshot or is there another way to do this.
Now that I am going to copy myself on the responses is there a way to hide certain information when the responses are sent to myself?
Yes, if you are using the notification method, and edit the delivery settings you can choose which columns come across in the email to yourself.
Alerts & Notifications > When a row is added > set up the email to yourself. And then Click Delivery settings > Edit (next to the all columns, comments and attachments) See screenshots.
Yes I am using this method already and I am clicking on the bottom of the form to send a copy to myself as well since this is what I would like the form to look like in the emails going forward.
Please see screen shots
I have a monthly report I send out that has a long list of recipients. I know I can edit the recurrence of it being sent, but does anyone know of an easy way to just add or take out people that get my email without having to recreate the whole thing?
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…
