-
Automation Email in Two Different Formats
I saved a sheet as new, in a new workspace, and my automation is working differently on the original sheet vs the Newley created sheet. The automation is exactly the same (Send x row in an email with x specific columns to x person) When I do it on the original sheet it gives me the full row horizontal view that is neigh…
-
How to not copy child rows using sheet to sheet workflows
I have a sheet with a helper column and conditions set in place to have a row copy to a different sheet however, when the automation runs, it still copies any child rows to the sheet. My workflow is currently setup as: Trigger: When Meeting Topic is checked Conditions: RAID Type is not blank Copy row to new sheet then…
-
Automation - Cancel Update Request Based on Conditional Logic
Is there a method to use a workflow to cancel a pending update request? Let's say I have a user who receives an update request through a reoccurring workflow, and rather than use the Update Request form in the notification, they opt to edit the sheet directly. Even though they have fulfilled the function of the update…
-
Record date and person who last attached a file to a sheet
I love data shuttle - and have built so many of them into my systems, both automated data shuttles and integrating data on attachment. We are a team of 2 people managing a common database, we have divided our tasks up into weekly and monthly tasks. We swap who is responsible for these tasks on a monthly basis to shake…
-
Automation Not Triggering On its Own When Trigger Criteria Met
Hi - I am using Smartsheet to manage our cutover plan for a software deployment. I have 2 columns that populate a Yes/No value automatically based on a formula calculation. Those columns are called 'Trigger Date' and 'Trigger Time Comparison'. The 'Trigger Time Comparison' is always the last column to flip to Yes, so I set…
-
Record a date automation not working?
I have a task list, and I want to use automation to supply the date the checkbox gets checked. Here is my workflow: Am I misunderstanding this workflow? Do I need another condition in there somewhere? Absolutely nothing happens in this sheet when I check the boxes. Thanks!
-
Wasn't there 1 email sent for multiple approval requests?
Hello! I have an annual process where I trigger an approval workflow to approve/decline the way controls are written. Previously there had been one email that was generated for all of the approvals assigned to the same person as long as they were triggered at the same time. I just tested the process and sure enough that…
-
Date Added when my Primary Auto Populates?
Hello! I am trying to find a way to use an automation or something of the sort for when a specific cell is no longer blank. Context: Primary Column is linked to a hidden auto-numbering column The "Date Added" Column was working for a while but every now and then the sheet will add about 5+ empty but numbered rows at the…
-
Help with cross-sheet references
I am having some trouble understanding this. I have a form connected to a large gathering sheet where individual peoples info is all tracked by a 'Unit' or team. I have automations set up to separate each units info from the form to that individual unit (So I have one form collecting 25ish teams form info, and then it gets…
-
Copy rows to create historical data
Hi - I have a metrics sheet that calculates different metrics from other sheets. At the end of each day I'd like it to copy those metrics over to a historical tracker so I can create a chart of how each metric moved over time. This is my metrics sheet I'd like it to copy over to an identical historical data sheet but into…