-
Linking contacts from sheet A to sheet B
I am trying to connect contacts from Sheet A to a workflow automated message from a form in Sheet B. Is something like this possible? Sheet A is a database of people listing names, skills, locations, emails, etc. Sheet B is fed by a form, I would like new rows to trigger a workflow to send an automatic message to a subset…
-
Automated Workflow - Alert only specific email addresses
We want to reduce the amount of notifications that consultants receive. However, the clients would still like to get notifications. Is there any conceivable way in a multi-select contact column to restrict notifications to only specific email addresses? To clarify, is there a way to restrict notifications (alert…
-
Automation help: how to email alerts to a list of contacts in a separate Smartsheet
Hello, I'm trying to set up an automation to send an alert to email addresses that are in a separate Smartsheet. My first Smartsheet is set up to collect the results of server upgrades. I then need to email these results out to a sizable number of contacts that are in a second Smartsheet. This list of contacts can change…
-
How to automatically move Parent & Child tasks to new sheet
I love the automation to move rows to an archive sheet once completed. Is there a way to move the parent and child projects together? This would only occur once all child project have been completed.
-
Attachments not attaching through automation email
I am trying to set up an automation so that when a row reaches a certain stage, an email alert goes out. In that email, I wanted to include any attachments from that row. I have done multiple tests, and sometimes the attachments are there and sometimes they are not. I have ensured that the attachments are uploaded prior to…
-
Generate rows equal to number from form
Hello, I'm trying to use a form to submit the number of rows that I want to populate, and I'm not too sure how, or if it's possible, to do so. Essentially I'm looking to use the Auto Number column to generate ID's for a given number parts that I'm making. For example, I will make 3 parts today, enter "3" in the Form, then…
-
Generate Documents - Global updates Control center
Need the ability to push global updates to the Generate Documents feature. We will have 900-1000 active jobs in control center that will be using Generate Documents feature. A few BIG problems If it is not set up at the front, you cannot add it to all active projects. If you have a document in 900 projects and you need to…
-
Developing Library check-out list
Hi! I am looking for suggestions/help on a formula for a library check out sheet. In columns I haveL check out date / Number of Copies / Copies Available. I am struggling to figure out an automated process to get the copies available to update once when the number of copies is changed. When the form is submitted it says…
-
How do I customize the subject line for the email notification from a conversation @ ?
Is there a way to customize the subject line for the email notification that is sent when someone @'s you? We have multiple conversations on the go in our intake request sheet but the email notification is generic and only has the sheet name so the people responding do not know which request the conversation is for. We…
-
URL Responses in Forms
Is it possible to have an end user provide URL link(s) as a response entry in a form for one or more fields within the form, and then have the automation workflow email provide its live URL link(s)? Currently when the end user provides links in a field within the form, the automation workflow email responses come back as…