Quickly Re-assign row assignments to another user

Tony Hatton

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å

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!

Best,

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!