I have a workflow with (9) conditions. Basically I want it to say:
WHEN a subitem status changes to "Action Needed"...
IF [number value] is equal to 2, Change Item status to X, ELSE
IF [number value] is equal to 3 AND all Statuses of [number value] = 2 are DONE, THEN Change Item status to Y, ELSE
IF [number value] is equal to 4 AND all Statuses of [number value]=3 are DONE, THEN Change Item Status to Z, ELSE...
and so on and so forth. I am trying to set an item status based on multiple subitem statuses of things that happen in a parallel processes under the item but perhaps in different departments.
I can't use different groups, or different boards - all subitems must remain under the same Main Item on a single board.