-
Move or copy row workflow results in empty rows in destination sheet
I have set up a few workflows that copy rows from an interim calculation sheet into a destination sheet for history/time series purposes. Whenever I set this up, I run a few test cases to make sure it working okay before I let the scheduled workflow take care of this automatically. This means, I have a few test rows that I…
-
Send a workflow alert to a specific person based off a form drop down question
Hi, I have a form where the user can select between a few people as the person they who is in charge of their project. I then made a workflow that says Trigger: When rows are added or changed When: "the form question" changes to Any Value Run workflow when triggered I then made several conditions side by side, 1 for each…
-
How can alerts show everyone who is copied on it?
Hi there, We are using the alert workflow for our invoicing process. In our process, we don't have any one who has to actively approve anything, so that's why we don't use the approval workflow. However, certain people need to be copied on the invoice requests to AP. I've set up the alerts, but unfortunately no one can see…
-
Move Row w/ Formulas
I have 3 sheets that are being used in tandem: Sheet 1 Registration Data Sheet 2 Travel Requests Sheet 3 Cancelled Registrations Sheet #1 has a "registration status" field (dropdown). This field is being pulled into Sheet #2 by using an Index/Match formula. If the registration status (on sheet 1) changes to cancelled, I…
-
Workflow Trigger Timing?
Does the workflow trigger activate when the sheet is saved (manual or auto) or is it when the actual change to the trigger field occurs? I am presuming the sheet has to actually be saved for the trigger to activate. Appreciate your feedback.
-
Group automation workflows on sheet
Hello. I have an approval sheet with 11 categories. Each category contains automation workflows with between 5-7 steps each. My workflow window is very messy and complex. Is there a way to group each category of workflows into a "folder", or some type of set? If I can do this, is it possible to clone an entire set of…
-
Create Workflow with 3 different conditions and actions
I am trying to create a workflow with 3 conditions, each having a different action. Is this possible? In my first attempt I set them up just one after another but only the first condition/action combo is working and I am not sure where to go from here? To try and clarify what I am trying to accomplish see scenario: I have…
-
Master work-flows in JIRA?
From what I can make out, I can only have a 1:1 for work-flows and sheets, and not a master work-flow which can be repeatedly used across all new sheets created. Is a master work-flow possible?
-
How to automatically copy the approved documents into another grid or sheet?
Hi, I have a grid or sheet where the rows which document status is already "SPC-approved" need to copy or populate to another sheet called "Approved Docs". Is there a way where this Approved-Docs sheet can automatically copy or get those rows with "SPC-approved"? Please lead me to an idea like formulas, automation…
-
How can I compare two date columns in an automated workflow?
Hi! I want to create an automated workflow which copies rows where two date columns are not equal to another sheet, how can I do this?