-
On a sheet, can you have rows moved to the top?
We are using a sheet to track a project we are working on. I have set up conditional formatting so that when the project status changes to "Completed," the entire row greys out. Is there a way to move that row to the top of the sheet so that only outstanding items are displayed at the bottom? Currently, I have it filtered…
-
Removing duplicate rows in a sheet
Would love to see a feature to remove duplicate rows in a sheet. I have an automated rule setup to move rows into a sheet every day and some of the rows are duplicates. I would like to automate the process of removing those duplicate rows.
-
I have a Move automation it disappeared from first sheet but didn't appear on new one
I had an automation that I created that had previously functioned. Basically the user check a box in a column and once the check box is selected the row is deletes in the original sheet and should appear in the new sheet. I'm a little concerned because I used the move command and it disappeared from original sheet and just…
-
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.
-
Merged: Move or Copy Row Automation should allow for Select Field handling
This discussion has been merged.
-
Limited Capacity on Sheet and Loading Time
I manage creative services projects for a large healthcare organization, we use one sheet that has several linked reports. Loading time is slowing due to the large number of cells and I will need to move rows. I have asked this question to the SS support team several times and have not gotten an answer. “Could you please…
-
Merged: Move Rows to TOP of another sheet
This discussion has been merged.
-
Automation is moving all rows instead of only those that meet the condition
Hi All, I have automation set up to only move rows where the summary checkbox is checked*. I added summary 2 and 3 to run more tests since this isn't working correctly. No matter what column I choose for the condition (Summary, Summary 2, Summary 3), it's still moving all the rows. I have no clue what's happening here so…
-
Automation in Template not Working
I have a template that has an automation that moves rows at a certain time of day to another sheet. When certain users create a sheet using the template the automation is unable to run. with the error "unknown destination". I need some help. Do all users need access to the destination sheet as well? I want to avoid that.
-
How can I copy a row from sheet with cell links to antoher sheet? Reccuring workflow not working
Hi all, I am trying to COPY rows automatically when a project owner name is changed from the original sheet to a destination sheet. The original sheet has cross links to another sheet and hence, I tried to use recurring workflows. Neverthless, not able to find the desitination sheet in the search box. I have tried to write…
