workflow automation - rows aren't moving?
I created a workflow to move rows once a column status is changed to "complete" within any row.
But the workflow didn't trigger, even when I manually changed the status to something else and back again, saved, refreshed, tried again. It finally worked when I moved the row to a different spot in the sheet (shifted up one to trigger the "add/change row") and then the row disappeared from my primary sheet.
I don't think I should need to actually move the row to trigger the workflow, and also, the row never appeared in the secondary sheet, so now my data is missing.
Both sheets are saved in the same workspace, and they have the exact same formatting (the second is a blank copy of the first).
What went wrong, and how do I fix it?