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!

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi @Vicky.Malhotra

    I hope you're well and safe!

    You could do it manually or add a so-called helper column with a checkbox to trigger it.

    Another option would be to use conditions in the workflow so it only triggers when you want it to.

    Would any of those options work/help?

    I hope that helps!

    Be safe, and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!