-
How do I move certain values from one sheet to a different sheet?
My attempt: Step 1: Sheet #1 get populated with new values (via a form submission(s)) Step 2: When Sheet #1 has a new value/row, only certain columns get populated into Sheet #2(i.e. ID number, case name, details) I tried the automation feature, but the whole row gets copied. I want it so that only certain…
-
Need advice on moving auto numbered data to another sheet with other auto numbered data.
Hello, I'm wondering if anyone has a work around for this scenario. I have two sheets: Sheet 1 - New Project Requests - includes the auto numbered column NPR ID# Sheet 2- Active Projects - includes the auto numbered column PRJ ID# When an NPR is approved for work I want to copy the row data from Sheet 1 to Sheet 2 but each…
-
Moving large amounts of rows
I'm trying to move 10s of thousands of rows. Automation does not work, it usually fails after trying for a few minutes. Is it possible to save sheet as new but retain the "created date" data? I need to move the rows one way or another without changing any of the fields (modified column doesn't matter in this scenario) I've…
-
How do I get the Move and/or Copy Automation to work properly?
This automation with work for a short period then stop and show me this error. Of course there is going to be a matching a matching column. How do I avoid it?
-
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
-
Moving rows to another sheet
I am trying to set up an automation where rows are moved to different sheets based on an account number. I have 4 set up just fine but I have 3 more that when I go to choose the sheet I want it moved too, it's not available. I am the owner of all the sheets and all sheets were created more than a week ago. I tried to…
-
Block of Rows Seemingly Moving by themselves
We are having an issue with rows seemingly moving on their own. Usually it is 2 -5 rows. We do have multiple users of the same sheet. AT first I thought it might be the one computer makes the change and doesn't save and the other computer makes a change and saves thus overwriting the 1st computers changes. This however…
-
Is it possible to move rows in the same sheet keeping the comments and attachments?
Hi, We work with a sheet for delisted items moving items there from the main sheet and we would like to keep items ordered by clients (as in the main sheet). Using copy/paste, I couldn not keep comments or attachments. Also, is it possible to keep the cell history when moving rows in another sheet? Thanks!
-
Problem moving rows within a sheet
Hello. I am experiencing problems with a simple select and move of any row within a sheet. In the screenshot below I have highlighted row 2002 and am looking to drag it down to between 2006 and 2007. However it ends up being placed between 2003 & 2004 (where you can see a faint blue shading). This is really annoying as I…
-
I try to move row and I get an error that does not seems to make sense
here is the error message: There is no formula anywhere in the sheet.
