-
Ability to modify a re-occurring send list when sending a report from Smartsheet
Currently there is no way to edit an send list (email addresses) when sending out a re-occurring of a report. I am having to set up a new re-occurring send list when someone new needs to have a copy of the report. Also, we have users that are no longer w/ the company and they still remain on the send list.
-
Data Shuttle connection to Sharepoint disconnects randomally
I have a recurring Data Shuttle process and randomly it'll stop running. Upon inspection, I'll see the connection between Sharepoint and Data Shuttle has been disconnected and I'm forced to authenticate again. Has anyone experienced this or know if there's any documentation about this?
-
Embed Smartsheet fields into Automation emails
It would be great if we could embed Smartsheet fields into the body of an automation email. For example, I have several emails going to different departments and if the auto email could be set-up like below, it would save time, clicks, confusion, etc.: <<Smartsheet field1>> has submitted a new request. The request…
-
Record a Date automation not running
I have a summary sheet that has a date (column type is set to date). I have an automation which should run every night at 9:00 p.m. to update the date to the current date (so the sheet will update automatically). However, the automation never runs. Any ideas?
-
Automation - Record a Date
I have a question regarding how to use the automation to set up the following: when the Notes column is changed, it will record the date. However, it keeps saying I don't have the Date column and actually I have a Start Date column in my Sheet, so I don't know what's wrong with this. Would you please advise me on how to…
-
Automation to change cell which has drop-down values does not work
Hi all, I'm using the automation function to synchronize 2 columns (see below). Essentially I have a column on a sheet which I called "Project Status" which is referenced out to another sheet. If this sheet is populated with a status, it should trigger a change in a drop-down column next to it called "Current Status". I've…
-
How can I tell where the automation email fail is coming from?
My IT Dept. says Smartsheets is whitelisted. They show no record of any emails getting blocked. However, my automation is to send an email when a row is added from a form and now no emails are going out to anyone. I even tried Run Now and nothing is going out. Is it Smartsheets? Is it down? It worked two weeks ago when we…
-
CopyRow Automation Not Working or Glitching
Hello All, We've recently had a few issues regarding the CopyRow Automation. We have our stakeholders submit project request from the source sheet to a project tracker/list sheet (destination sheet). However, there have been a few cases recently where the automation didn't run when all of the criteria were met, causing…
-
Assign Contacts to Child Rows Based on Criteria in Parent Row
We have multiple stages in our projects that are set up with a parent row and then child rows below. I would like to assign a contact to the parent row of a stage and have that contact automatically assign to all child rows below. Is there a way this can be done without add-on software?
-
Automation notification to Shared email account.
Hi good afternoon, everyone. I am trying to set a Shared email account into the notifications automated email every time that someone add a new item in a sheet. Unfortunately, I receive this message when I input the email. Any solution to this? What i am looking is that every time that somebody submit a new item (via form)…
