Workflow with Two Conditional Statements Not Firing

Bethany Garcia

I am trying to create a workflow that will send one daily notification of all rows that meet one of two criteria. In simplified terms here is the logic I have:

If

Department = A, B or C AND Manager Approval = Approved

OR

Department = D AND Executive Approval = Approved

THEN

include in daily notification email.

The problem I'm running into is that if I put the condition statements in the same path, no notification is being sent (I think it's because it expects both conditions to be met when they are on the same vertical path). If I create a new conditional path for the OR statement, it will then send two separate emails, one for each statement. I want to have one email sent containing records that meet the criteria of one or the other statement.

Is this possible?

Jeff Hoelzel

One way you could do this is set up a code using a logic formula on your sheet and trigger your workflow to fire off one email per day based on the the code. For example, say if condition one is met, then have the formula calculate a "Y" in your code column. If condition two is met have the formula calculate a "Y" in your code column. You can lock and hide the code columns to keep your source sheet clean. Set up your workflow based on changes to the code column and decide which columns, like the Department and Approval columns, you want to include in your notification if any.