Workflow to Move ROWs - Row Limit on Destination Sheet

Christine Cao

Hello Community,

I have set up a workflow to MOVE (duplicate) rows to another destination sheet because I'm not aware of a workflow to "DELETE" the duplicate row.

First question - am I correct that there's NO workflow function to "DELETE" a row? Only option is to MOVE the duplicate ROW to another sheet. This is working however the destination sheet appears to have a limit of 4000 rows and once max it reached, the workflow cannot run, which I'm not even notified. I have to check manually and switch out the destination every few weeks. This is such a pain.

Is there a better solution? Thank you

MichaelTCA

Hello @Christine Cao

Yes, you are correct that there is no Delete Row automation. Clear Cells would be the closest to deleting data without moving it to another location. I do not recommend trying the Clear Cells automation to delete mass amounts of data. It can get messed up quickly.

If you don't mind me asking, why is there a limit of 4000?

You should be able to use up to 20,000 rows, as long as you don't pass the maximum amount of cells.

I use a similar setup to archive data. That way we can still maintain reports and use the logs as planned and clean as possible. I created multiple sheets for archives and set up the automation to have multiple condition paths.

For example, if the archive is based on the year, the condition will say what year is required to be sent to that sheet. I'll set up 5-6 archived logs and check back in a year or two.