Workflow rights when copying a row

I have multiple sheets which have a workflow setup to copy a row into a specific sheet. All works well as long as the person who owns the originating sheet is a admin on the destination sheet. However, I do not want them to have admin rights to that sheet, i only want them to have editor rights which I believe should still be okay but its not. When I switch their rights to the destination sheet the workflow throws and error that the destination sheet's rights have changed.


Any ideas? Thanks in advance...

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!