How to use automation to copy only certain rows to another sheet?
I have large rows of dataset in a sheet. I am looking for a solution that can copy specific rows to another sheet based on certain criteria.
I used the automation template for copying rows, however, on fulfilling the condition specified, the automation all rows in the primary sheet to the secondary sheet. Is there a way I could move only specific rows to a different sheet? I don't think smartsheet has the filter function else that could have done the job
Thanks in anticipation!
Help Article Resources
Check out the Formula Handbook template!