This discussion has been merged.
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 parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent row. Is this possible?
My workspace has 3 main source sheets. Each of these source sheets currently uses a different column for the primary column (two use ID Number, one uses Name since ID number is assigned later) but both columns exist in all sheets. When a request (1 row = 1 request; form intake) is marked completed it moves to its…
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…
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…
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.
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…
