-
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.
-
How do I run an automation after the row has been created?
Trigger won't work if the row has been created, and no change. Automation is an after thought... If the row has been created and saved and I need to Automate actions, such as moving a row to another sheet if it contains a certain status, how do I run it? It won't let me run this Hourly or Daily... If I manually run it, it…