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 th…
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 t…
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?
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…
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 …
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 a…
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 commen…
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. …
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 s…