Quickly Re-assign row assignments to another user


I have a lot of projects on separate sheets within Smartsheet which have rows assigned to users. If the user leaves the company, I can reassign that user's sheets to another user, but is there a way to re-assign the rows they are assigned to?


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Tony,

    There are a few workarounds.

    If they are linked through formulas or cell-linking you could change it in one or a couple of places and every assignment would be updated.

    You could use a report to show the assignments and change them there.

    Make sense?

    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 help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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