-
Streamlining Production Planning: How Smartsheet Integration Saves Time and Boosts Efficiency
One of our clients faced the challenge of their planning team constantly needing to check a shared Google sheet throughout the day. The process of reviewing the data multiple times and manually updating the schedule was time-consuming and prone to errors. Missing any crucial information could potentially disrupt their…
-
Alert Someone automation unable to run
I have a pretty simple automation built that is set to email a specific email address when a value in a certain column changes. It states that it is unable to run because "this action has no recipients that will be able to receive notifications based on this sheets permission settings or this accounts approved domain…
-
Merged: Required Fields in Automation Workflows
This discussion has been merged.
-
Remove an update request with a formula or workflow?
I have a sheet that will automatically request an update if certain parameters are met. But sometimes the fields get marked directly through the sheet instead of through the update request form. Is there a way to automatically remove the request update if the parameters are met through the sheet? For example if there is an…
-
Automation - Moving to a row to a new sheet once a date has passed
Hi, I need help with some automation. I want to move a row to a new sheet once 2 weeks have passed. This is due to a report we have on newly completed vs. historical completed items. Is automation based in calendar or business day? For some reason, my automation does not consistently work. I have tried this automation: I…
-
How can I verify an update request was sent?
I have an update request workflow that sends to contacts in a cell and is triggered when a specific dropdown value is selected. After setting the value and saving the sheet, there is no update request icon on the left side of the row and they are not appearing in the update requests panel. However, the workflow itself is…
-
Use a form to answer a question and provide the person to inform
I'm working on a two step process where employee 1 completes a form. In the course of completing the form they answer two questions: What decision did they make? What employee (employee 2) should it go to next? I want employee 2 to get an automated notice but since I'm filling in the row with the sheet it won't send the…
-
Adding a Program in Control Center
I have (1) program in control center, I'm trying to add an additional program for another department, I'm not finding any option to add. Can additional programs be added?
-
Automation Not Responding to VLOOKUP
Hello Everyone, I have some data coming in from DataShuttle every morning to update status on pieces of work identified by 'OMNI #'s' (ex. OMNI123456). I have a formula in my sheet that looks at the OMNI number we put in then goes to the import from DataShuttle to find what the status was updated to that morning. Here is…
-
Automate Access to Workspace
Hi everyone, I have a workspace with a variety of sheets, reports and dashboards. I am using a sheet to keep track of who has access to the workspace (as a "user sheet"), which is also connected to a separate third-party automation I had developed to associate users to their submissions via other sheets (which is working…
