I need an "IF A AND B/THEN" workflow in - but I can't figure out how to add the AND condition in the workflow.

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.

3 replies