-
Merged: Allow Mandatory (Required) Fields in Update Requests Triggered by Automation
This discussion has been merged.
-
Updating template -> updates sheets made from the template
I would love to have the ability to make a change to a template that I created and be given the opportunity to select sheets that were created from that specific template to automatically update as well. For context: I keep track of ~130 employees training records. Each employee has their own separate sheet with all of the…
-
Extraer la Hora de 2 o mas celdas
Buenas tardes, como podria extraer la hora de registro de 2 ó mas celdas? o como podria registrar la Hora en una celda?
-
Automation: Ability to add a condition to workflow branching off from an unmet condition
Today in automation workflows you can only and conditions to flows that pass previous conditions. It would be helpful to be able to add conditions to the flows that stem from failing previous conditions. Scenario: I want automation to change the status of a task based on it's Target (completion) Date and it's Actual…
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
-
Is there a way to include the Sheet Name as a variable in a message?
Based on this KB article (Dynamically Add Cell Data in the Subject and Body of Request Messages) I know that we can include the names of columns (like {{Name}}), but I want to update the subject to include the name of the sheet itself (like {{Sheet_Name}}. Context: We have created a contact list template, that has a form…
-
Is there a way to do an export of the automation workflows?
We have over 20 automation workflows setup on a worksheet. Is there a way to do an extract of these workflows to review rather than going one by one?
-
Auto-Revoke/Cancel Update Request
I have an [Assigned to] contacts column with multiple contacts per cell allowed. Based on certain criteria I have a workflow setup to send an "Update Request" to all of the contacts in [Assigned to]. However, I only require 1 (one) of the contacts to provide the requested update (as they chose based on their availability).…
-
Dynamic View does not allow anyone to change and save specific column
I have a column with a dropdown list. The column is restricted to listed values, and you can select more than one. There is no logic assigned to that column in the dynamic view, and is not listed as required. I've tried disabling the conditional logic on the sheet, and it did not correct the issue. This is happening to…
-
How do I display the username of a modifier of a specific column?
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…