-
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,…
-
Auto Attach Report .pdf to new source sheet row
Is it possible to take data from a Report and have it auto export as pdf/excel file and attach that new file to another sheets row? Case: We have a User Access process built and once a month, the primary owners of each software need to review the user access as a pdf file. We were using the "Send as Attachment" feature in…
-
Multiple columns condtional furmola/formate
Hi , I have fleet of cars my drivers manually on daily basis type the KM/Millage reading in Column (Km/Today) I need formulla for column Alert as follows: - - - - - - - - - - - - - - - - - - -- - - - If number in col (Oil Next) is less than col ( Km/Tiday) the alert Col is (Green) AND If number in col (Oil Next) is Higher…
-
Move Automation seems to be timing out or conflict
I have a move automation triggered from a cell update. There are currently about 900 records that I would like to move to a separate worksheet. The worksheet contains about 170 columns that would be moved. There are multiple people in the worksheet throughout the day. Additionally, there are other automations launching…
-
Add Source Sheet When Copying Rows to New Sheet
Is it possible to put a link to the source sheet that a row was copied from in the copied to sheet with a formula so it adds the source each time? Sort of like a report will give the source sheet. I'm copying rows to a rollup sheet, but I'd like the roll up sheet to have the link so it is easy for the used to go to the…
