Move rows to new sheet

Options

Hello,

I am trying to set up an automation that moves rows from one sheet to another, I have successfully done it with the Copy automation but need to move the rows this time. When trying to set it up and I select which sheet it will go to, the sheet I decided was not there. Only two sheets showed up but neither was the one I wanted it to go to. Is there something more I need to set up in order to see the sheet it needs to go to?

Thanks in advance!

Answers

  • Genevieve P.
    Options

    Hi @Desertbird

    It sounds like you're an Admin on the current sheet where you're building the workflow, is that correct? If so, you'll just need to make sure that the Owner of this current sheet is shared on the other sheet with Admin permissions as well (essentially you can't steal rows away from the Owner, they need to have access to the destination location).

    Once you've shared the Owner to the other sheet, it should appear as an option to select in your workflow.

    See: Automatically Move or Copy Rows Between Sheets

    Cheers!

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!