Create Workflow with 3 different conditions and actions
I am trying to create a workflow with 3 conditions, each having a different action. Is this possible? In my first attempt I set them up just one after another but only the first condition/action combo is working and I am not sure where to go from here?
To try and clarify what I am trying to accomplish see scenario:
I have 3 final sheets A, B, C.
I want certain rows in my data sheet to be copied to Sheet A, if a specific check box is checked (trigger) and if dates in the row fall between a specified range, 01-Jan to 06-Jan, which is my condition.
If the dates fall between 07-Jan to 13-Jan, I want rows to be moved to Sheet B.
And then if dates fall in 14-Jan to 20-Jan, I want those rows moved to sheet C.
Basically, I have 3 sheets that need rows to move to them depending on the dates in their dates column.
I initially set it up to identify trigger, then 1st condition and action and then added another condition and action and then third. Didn't work. Only first condition and action triggered.
Thoughts? Is what I am asking for impossible? Or what am I doing wrong?