-
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…
-
Dynamic Reporting Linking Filters
I would like to make reports dynamic so that you can link filter options to another sheet. For Control center this would be great because you can have the intake sheet (Where the data lives) drive into the report and populate the results. We would like to see it linked so if you change the data on the intake sheet, the…
-
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…
-
Roll-up multiple projects by "assigned to" and NOT TO BE A REPORT??
Hello beautiful community of SmartSheets, The client wants to use the card view of smartsheets but not in smartsheets itself but via Microsoft Teams, which is a great integration platform, the problem is that when you integrate a report via teams, is "View Only" so the client can't move the cards around or check tasks that…