I am trying to set a workflow for an existing sheet, I have Admin permission. Once the rows meet a certain criteria I need them moved, one sheet to another. I created the new sheet, to where the rows need to be moved, which makes me the owner. However, when creating the new sheet, it creates a whole new workspace, like why? When setting the workflow and getting to the last step, I cannot find the sheet where I need these rows moved. I am wondering if the reason for this is because this sheet now is part of a different workspace.
Is anyone having the same issue, is there a solution for this? Any feedback helps.