-
Copy Rows according to Multi-Dropdown
I have an Intake Sheet in which someone can select multiple Locations and multiple Fiscal Years that the Initiative will occur in. What I need is for this row to copy to the Retail Master Sheet a total of 6 times - one for every possible combination of the selected Location and Fiscal Year. DESIRED RESULT - My current…
-
Is it just me or have URLs stopped working in Alert/Email automations?
We cannot click URLs in Smartsheet alerts, update requests or approval automations. Is this everyone's experience? See how the URL is not clickable
-
Notification Automations - Links in messaging
When creating a notification automation that includes a url directing a receiver to a report, dashboard etc., sometimes the url that I copy and paste into the message us not clickable, and the receiver has to copy and paste. Is there a step that I am missing to make is a clickable link?
-
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets…
-
How to Implement Dynamic Dropdown among Two Sheets
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below script from Python Anywhere on an hourly basis, and I have shared this script so that anyone else can use it as a template for…
-
How do I dynamically update a dropdown list?
I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date. I was wondering, is there a way to upload values into a dropdown through an API? Otherwise, can I upload values into a dropdown from another sheet?…
-
Automatically add Child Sum to Rows
Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project. My problem is that while I can manually set this for the rows, these sheets…
-
Limit on workflows triggering other workflows (aka daisy chained autoamtions)
I have a "Re-Release" process that is very long and complex. At one point in the process, a row goes through a series of automations that trigger each other. These automations copy the row to an archive sheet, move the same row to a "Re-Release" sheet, copy the ID# to an "Previous ID #" column, clear the data in over 60…
-
Adding a PDF
I have a fillable PDF and want it automatically emailed when certain criteria are met in the sheet. Once emailed, recipients should be able to complete and reattach the PDF to the document. Is this possible? Our account includes all premium options, but I can't find how to do this.
-
Copy Row Workflow Delaying 16 Hours
I have a simple "copy row" automation that is delaying execution. Most recently, it delayed 16 hours - it was supposed to complete one afternoon, but did not until the following morning. It is working out of a very busy project tracker, so I assume there are too many workflows happening at the same time. How am I able to…