-
Is there a way to send an alert based on a non-contact list field?
I am trying to create an application in which users make a request of their supervisor and the supervisor approves or denies the request. I created a sheet with "employee name" as a contact list and "supervisor name" as a contact list. When I fill out the form and enter names in those fields, SS doesn't pick up that they…
-
Can you submit a document from a form and place the new row based on sheet heirarchy?
I have several vendors working on the same project. Each has a set of required deliverables that have to be submitted at regular intervals (weekly, twice monthly, monthly) during different project phases (concept, design, installation). I would like to use a sheet to track the submissions and create a form for them to use…
-
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?
