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 a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
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 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…
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…
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!
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…
here is the error message: There is no formula anywhere in the sheet.
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…
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…
