-
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…
-
How to get symbol to automatically update in destination sheet when it updates in the source sheet
I have rows copying over to a new sheet whenever column C is a certain name the box in column J is checked. Source sheet: Destination sheet: I would like a formula to automatically update the symbol in column L of the destination sheet to match the symbol in column M of the source sheet when the rows of columns A, B, C, D,…
