-
Workflows updates
Hello, I wanted to know if there is functionality for the following: I have two sheets, #1 Master and #2 Calendar. I have set up an automatic workflow: when a tick box on sheet #1 Master is ticked, a row is copied to sheet #2 Calendar. I then realised that if I needed to update anything on #1 (after the row was copied…
-
Recover Data Shuttle workflows
For large organizations, allow Admins to recover the sheets, automation workflows and data shuttle workflows created by users who have left the organization and assign them to other users who took over the respective role. Currently, the only option is to start over, which involves not only time and labor, but also…
-
Simple Workflow Not Triggering
Hi, I have a very simple workflow set up using "TODAY()" date as a formula. Basically it's a tracker with due dates, and if a particular task is not "Complete" by the due date, the status will change to "Overdue". Let me emphasis that there are no external links on this sheet and the formulas work fine. The workflow is as…
-
Copy row when certain criteria are met and edit data within the row
Hello, I am managing a list of products where our customers often re-order the same product the following year around the same time. I want to copy the product specifics to the bottom of the sheet once it is checked as delivered and add a year to the due date. This will allow us to plan for the product delivery the…
-
What do I do if my automations keep failing?
Good afternoon, We are trying to have data moved from one sheet to another every month using automations but we are running into the issue that once the sheet gets too big (too many rows) the automation will fail to move specific rows out. I am looking for a solution for this issue and an alternative to manually copying…
-
Workflow actions not being triggered by changing linked cell
I currently have 2 sheets, sheet 2 has dates cell-linked from sheet 1. In sheet 2 I wanted to use the "Change Cell Value" action whenever the linked date changes in the sheet to save "Yes" in a column called Date Change. However I see that even when the date changes the workflow is not being triggered. I have read that…
-
Order Execution for Automated Workflows
What order do the workflows get executed in? I have a workflow to move a row, but it can only be triggered right away. If that happens will other workflow items also execute? Other workflows trigger off the same change and I need ensure they don't get skipped.
-
Same Level Multiple Approvals
Is there a way to sent out a request that contains multiple approvals? There is a situation where we have a record that may contain anywhere from 1 to 3 approvals. All approvers have the same authority. To tally the approvals I would create a separate column that evaluates the decisions of either all approved, all declined…
-
Add project name to update requests
I have numerous projects that all have the same work breakdown structure. If I send out request updates (via automation) the end user doesn't know which project the request is asking about. Unless I specifically state what project I am referring to in a manual update request I don't see a way to have that info included. So…
-
Turn off notifications for everyone
Hi all, I have a single sheet within a broader workspace that the team does not want anyone to receive any notifications from. How do I do this? When adding a workflow, I only see options for alerting people when / if something specific happens, but I just want to turn off all notifications for everyone for the sheet.…