Logical operators in SPD2013 (nested and / or operators)

Question

I have a SP2013 list, which has 2 mandatory fields "Team" and "Client" that allows you to select:
1. Team (A, B, C; etc. until Team P) and
2. Client (A1, A2, A3, B1, B2, B3, C1, C2, C3; etc. until P1, P2, P3)

Clients A1, A2, A3 can only be selected with Team A
B1, B2, B3 - with Team B
C1, C2, C3 - with Team C; etc. (until team P)

How do I use logical operators in SharePoint Designer 2013 - Workflow Designer to get the following result:
If: Team A and Client: A1 or A2 or A3, then: email to Team A,
If: Team B and Client: B1 or B2 or B3, then: email to Team B,
If: Team C and Client: C1 or C2 or C3, then: email to Team C,
(until Team P & email to Team P)

The end result should always be an email to one of the Teams: A to P.

I would really appreciate your help.

Answer 1

You can write the Logic IN a SharePoint Designer workflow.. takes some clicking

It is easier to write a Calculated Column Formula and then have your Workflow continue with that

In Calculated Columns the Logical Operators are Functions

So OR is:

OR( Client="A1" , Client="A2" , Client="A3" )

But it is shorter to use a String operation:

LEFT(Client,1)="A"

Your logic of Teams A to P can be written as:

Team = LEFT(Client,1)

eg:

"A" = "A"

So there is either an Email to a Team ... or No Email

Create a Calculated Column MailToTeam with Formula:

=IF( Team=LEFT(Client,1) , Team , "NoMail" )

And then use that in your SPD Workflow