-
Copy a range of cells under a parent or ID number to another sheet
We have a wide range of purchase orders which can be created for any job from 1-50. There are about 6 different PO groups I would like to pull data from and assign them to their individual projects in their corresponding rows. Is there a function where I can call the parent and it will copy the parent and children…
-
Form: Change "From" on Automated Form Submission
Hello! My team at work recently created a form with an automated email response to confirm to the recipient that their submission was received. When this email is sent, however, it reflects the name of the owner of the sheet. I am wondering if it is possible for us to change the name to something generic for our team,…
-
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…