Is it possible to create a workflow to transfer indented rows to a separate sheet?
Is there any way for the workflow to trigger and move the indented row independently from their parent row to a separate mirrored sheet (exact same set up)?
My specific scenario:
Tracking form numbers that fall under different categories (series/subseries). The forms are indented to be nested under their respective series and subseries. When a form is marked obsolete, we would like it to move to our inactive forms sheet which is set up the same exact way. The workflow does not trigger because it is nested under the "parent" row.
My question: Is it possible to create a workflow that automates indented rows to be moved to another sheet? If not, what would be a good alternative to this issue?
Help Article Resources
Check out the Formula Handbook template!