-
Reminder/Alert Automation
I have this tracking ticket Smartsheet where every 2 weeks, my team of 4 analyst rotate on who's in charge of addressing these tickets. These tickets don't have deadlines, they just have quality information (e.g. ticket name, description, submitter, status, location of issue). I want to create an automated reminder for…
-
Automation workflows that were working are no longer emailing gmail and msn addresses
Our existing workflows that trigger automated email alerts have started failing. It started in the last day and only affects gmail and msn addresses from a contact column. The failure message is, "Due to a recent automation permission or sharing change, the following people aren't receiving alerts from your workflow".…
-
Move or Copy Row Automation should allow for Select Field handling
We use Move and Copy Row automation in many of our processes. One 'unfortunate' component of a Copy\Move action is that the ENTIRE ROW-all columns of data- must be handled in one package. Wouldn't it be great, if I could tell the automation specific columns to move forward? Example: Copy\Move entire row out of sheet one,…
-
Auto number column type and copy rows workflow
I have two sheets that utilize the auto number column for tracking two different things. sheet two has all of the data sheet one has, including the ID that is autogenerated on sheet one (manual input into sheet two), but it also has additional columns such as the autogenerated sheet two ID. I wanted to create a workflow…
-
Is there a way to copy or link an attachment from one Smartsheet to another?
I have two smartsheets. The first, Order Sheet, collects submitted order info from a smartsheet form. The second, Shipping Sheet, has shipping info for both submitted and other/autogenerated orders . I am using Index/Match to pull shipping dates and tracking info from the Shipping Sheet into the Order Sheet. I would also…
-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
Allow User to Expand the Text Box for Customize Messages in Automations
Please add the ability to expand the text box when writing text for a customized message that is part of an automation. In most software, this means an option to click on the bottom right corner of the box and drag it out to expand it. It is helpful to see the entire message when drafting it, and later when reviewing or…
-
Reduce Lag Time for Automation Triggering
The lag time to trigger Smartsheet Automations is extremely variable and often far too long (usually 1-2 minutes, but Smartsheet claims could take up to 15!). This is a frequent complaint from my users and significantly limits the utility of these features. I frequently need to use a copy or move row automation as the…
-
Automation Error Message
I have an automation set up send alerts to specific email address input in a column. My settings are set to unrestricted and 11 of the emails sent successfully. I got an email letting me know 'some recipients aren't receiving alerts…' and that this impacted 17 cases. When I tried running the automation row by row for 6 of…
-
Formula or Automation Help
Im looking for the best way to set up this formula/automation (whichever is best): I have multiple columns collecting different contact names by title from a form: I need a formula or automation, that when "Admin Reviewer" = yes, then it takes the contact in "Project Admin" and adds it to another column titled "PT Proof…
