Workflow to Move ROWs - Row Limit on Destination Sheet
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