-
Can i move child rows to another sheet and copy the parent row across too?
At the end of each quarter, i'd like to copy parent rows and move the previous 3 months (from each parent row) to an archive sheet. Is this possible? I'd then like to have an automation after this that adds 3 new rows under each parent row once a new quarter begins.
-
Assistance Needed with Date Archiving Automation
Hi there, I have a helper sheet that populates Office drop-down dates via DataShuttle. The "Date Requested" column contains drop-down options with dates, and the "Date" column is a date column (my trigger for moving rows. I want to archive each date row if it matches today’s date, but the automation I set up isn’t moving…
-
Automated Workflows
Hi Team, I have created a 4 tier linear approval workflow wherein the functionality works fine when we go through the Approve option for all levels. However, if the first one declines and the forms opens up at requestor level for update and they submit it….from their the next approver gets 1. multiple requests/ email…
-
Control Center Project Archiving - Update Project Profile Data
I am building out a Archive in control center to archive projects once they are complete. As a part of the process, I want to update the Project Profile data to update a sheet showing that the project is Archived. I have added a column to the intake sheet and the Summary sheet. In the Archive workflow, I see Update Project…
-
How to Reverse an Automated Task
Hello, I recently created an inventory tracking sheet and programmed it move a fully consumed material to a separate sheet. The parameter was "If rows are added or changed" when "fully consumed" is checked, then move row to "fully consumed" sheet. It was taking a long time to respond so I manually ran the automated task…
-
Remove duplicates based on Modified Date
Hi team, any suggestion is appreciated! I have 4 sheets: Sheets A-C: Individual project trackers Sheet D: Main project sheet What I need: Setting up a workflow that copies row updates in Sheets A-C over to the Main Sheet (Sheet D). This will ensure the Main Sheet includes all project statuses so I can report on them.…
-
Archiving Data
How do you go about archiving large data sets from sheets? I know you can create automations to move rows to another sheet but what happens when that sheet gets too large as well? I have thousands of entries that happen every day and I am trying to use data shuttle to offload the data but with offloads, it just replaces…
-
Archiving Rows
How do you go about archiving large data sets from sheets? I know you can create automations to move rows to another sheet but what happens when that sheet gets too large as well? I have thousands of entries that happen every day and I am trying to use data shuttle to offload the data but with offloads, it just replaces…
-
"Bulk" archive sheets/folders/workspaces
Provide a way to bulk archive assets and automatically remove all sharing, deactivate workflows, etc. (similar to Control Center). Current method of manually removing sharing and deactivating workflows on thousands of sheets is too time consuming.
-
Why is this happening all of sudden?
Hi all, I have had an automation set up (and working fine for quite some time) that copies a row to another sheet and then moves that row to a different sheet (Archive) when "send to Archive" is checked. As stated, this workflow has been performing perfectly for several months. Nothing in the source or destination sheets…
