-
Making automatic links between sheets
Hi there, here is the workflow: User enters data into a form (done). Form populates a sheet called Master_sheet (done). One of the entries of the form is a dropdown, lefts say for example: Dog, Fish and Cat There is an sheet called Dog. If the person who completes the form chooses the Dog option, the some new entries in…
-
Row Copying Issue
Hi I have a sheet, and in it there's a VLOOKUP to another sheet. I set a Copy Row Automation so that when the vlookup cell is filled, it should Copy the Row. I setup the Wrokflow like this: Trigger: When a Row is Changed When: <Field> Changes to Any Value Run Workflow When Triggered So, everything pulled into the sheet…
-
Automations - Enable field and status updates in Card Templates
It would be wonderful if Automations could make specific updates to field and status values when using a Card Template. For example, let's use assume I am using the following template structure: Status(s): Backlog, Current, Complete Field(s): Description, Due Date, Done (check field) Now let's assume I want to make sure…
-
Copy rows in automation leave original sheet but don't appear on new sheet
Hi- I set up an automation to copy rows with any value added in a specific column to a new sheet. When a value is added, the rows have disappeared from my original sheet however they have not moved/appeared in the sheet they were meant to be move to. Help!
-
Multi-Select & Automated Notifications
I'm trying to create an Automated Workflow for Requesting Budget Updates. We some times have to send out Update Requests for Monthly Budgets - obviously the number of months will vary client to client. My question is - is there a way (using Conditions, Formulas, etc.) that I can setup one Automated Notification that would…
-
Quick Auto Pop-Up Form As Part of an Automation
We have a sheet where all our RFQ's are entered. I have created an automation where as soon as the Status of the RFQ is changed to Sent it automatically copies the sheet to a Quote Register /Pipeline. I wondered if it was possible that as part of the automation, when the status is changed a quick form pops-up where the…
-
Current vs. Next Due Date
We have a list of software/hardware/contract obligations. Currently it is setup to provide 30, 60, and 90 day reminders (based on current the due date) to the interested parties so our contracts and licenses do not expire. I am wondering if there is a way to update a renewal date for the following year once it has been…
-
Using custom value for auto-number in primary field.
I read an old post that said use =[Row ID]1 to copy an automated sequence number in to the field specified. I want more that than just 1,2,3. I would prefer V00001, V00002 etc.. to increment for each new row. Is that possible?
-
Approval Workflow - Send to contacts in a cell
Hello, I am creating an Approval Workflow with "Unrestricted" Automation Permissions so that the approval request can be sent to any email. The Requestor is prompted to enter the "Approver Email" within the request form. When creating the workflow under "Request an approval" I have selected "Send to contacts in a cell" but…
-
How can I make my automation stop updating once a column is checked?
I am trying to set up an automation so that when a column is checked it copies to another sheet. The problem I am having is that anytime anything in that row is updated it is continually copying over. I want it to be a one time copy because I then have it mesh to another sheet.