-
New Automation Action to record User in Contact List Column
It would be incredibly useful to have the ability to automatically record a user in a Contact List column when a specific trigger occurs—just like how we can currently automate date recording. This feature would greatly enhance approval workflows by minimizing manual input, making the process more efficient and reducing…
-
how to send 2 different forms
Good morning, New to Smartsheet to still learning. Is there a way to automate sending an "invite" to someone on a date in the Gantt chart followed by a "poll" to the same group on a different date? My current thought process is to create different columns with "XYZ" and if XYZ is checked, run the "invite" script, and if a…
-
Automated Notification to include all Contact Lists on sheet
How do we set up automation so each Contact List POC can see who else was included in an email notice? For example. when you send a notice from a row then it allows for all on the contact list to be included in email and visible to each other in TO: however when we set up the automation then it only allows for the email to…
-
Is there a way to remove blank rows from an automated email?
I created a form, that has logistics factored into it so when one question is asked depending on the answer, a box may appear to continue down the form. When the form is submitted and i recieve the email notification, all the boxes on the form appear even if they are blank. Is it possible to adjust this so only the boxes…
-
Update Request using a Form
I am creating a SmartSheet that we will load specific rows to it. I then would alert the contact of their row via Alert Someone workflow. Then the person would have to update a couple of columns/fields in the Smartsheet. Here is my problem: The Update feature doesn't give you an option (that I know of) of formatting the…
-
Copy Sheet w API doesn't copy over "Cope Rows" Automation action
I am using the Smartsheet SDK When I copy a sheet using the API (either by copying a template w/ client.Workspaces.create_sheet_in_workspace_from_template or client.Sheets.copy_sheet) I can use the "include" query parameter to capture conditional formatting, forms, and automations copy over, but a specific COPY ROWS action…
-
SmartSheet Automation and Sheet Update Delays
I've ran into an issue when trying to maintain a sheet. Triggered settings within automation to send out emails to assigned users have been receiving delayed emails anywhere from 1-2+ hours. Is there an explanation on what could be causing the delay? Initially there were about 40 automation flows setup to send to various…
-
How to get rid of the "Reminder" as the 2nd row in my slack alerts
See screenshots of my automations set up and slack alerts. I want to get rid of: row 2 of slack alert: Reminder row 1 of slack alert: Reminder to schedule testing for BD_Proteinase K (Item ID: RGT0172_01, Lot #: 209482) row 2 of slack alert: Reminder row 1 of slack alert: Reagent BD_Oligo Binding Buffer (Item ID: RGT0173,…
-
Latest Comment Copies Wrong Time
I have two columns that I have users enter data, formula combines it with the current modified date and time, then automations copy those rows to another sheet, so the history is preserved with the time. I then use the JOIN/COLLECT trick in new columns on the original sheet to show a log of that data change over time. One…
-
Automated emails
Hello, I created a Grid sheet with various columns and wanted to generate automated emails out of it. I need a solution for the following that:The existing columns are Granted By, Granted To and Valid Until. I want a automated email to be sent based on the below requirements: "Legal requirements" field = legalization (with…