+ Start a Discussion
Jessica EaganJessica Eagan 

Data Classification with Exception Formula

Hello,

We are attempting to group Contact Titles into a Roles Custom Contact Field.  Here is what we have so far:

The issue:  We want to add an IF(CONTAINS(Title, "AP"), "Finance",       BUT it is pulling in anything with AP in the title.  Is there a way to run the IF CONTAINS, and then an exception like but NOT(CONTAINS(Title, "SAP"  ??

Any ideas are appreciated!  Thanks!

IF(CONTAINS(Title, "Assistant"), "Assistant",
IF(CONTAINS(Title, "Basis"), "Other",
IF(CONTAINS(Title, "Supply Chain"), "Other",
IF(CONTAINS(Title, "Security"), "Other",
IF(CONTAINS(Title, "Chief Financial Officer"), "CFO",
IF(CONTAINS(Title, "VP Finance"), "CFO",
IF(CONTAINS(Title, "Vice President Finance"), "CFO",
IF(CONTAINS(Title, "Chief Information Officer"), "CIO",
IF(CONTAINS(Title, "Accountant"), "Finance",
IF(CONTAINS(Title, "Accounting"), "Finance",
IF(CONTAINS(Title, "CFO"), "CFO",
IF(CONTAINS(Title, "CIO"), "CIO",
IF(CONTAINS(Title, "VP IT"), "CIO",
IF(CONTAINS(Title, "Vice President IT"), "CIO",
IF(CONTAINS(Title, "IT"), "IT",
IF(CONTAINS(Title, "IT Manager"), "IT",
IF(CONTAINS(Title, "IT Director"), "IT",
IF(CONTAINS(Title, "Information Technology"), "IT",
IF(CONTAINS(Title, "CEO"), "CEO",
IF(CONTAINS(Title, "Chief Executive Officer"), "CEO",
IF(CONTAINS(Title, "Operations"), "Operations",
IF(CONTAINS(Title, "Operating"), "Operations",
IF(CONTAINS(Title, "COO"), "COO",
IF(CONTAINS(Title, "CTO"), "CTO",
IF(CONTAINS(Title, "Chief Technology Officer"), "CTO",
IF(CONTAINS(Title, "Chief Technical Officer"), "CTO",
IF(CONTAINS(Title, "VP Technology"), "CTO",
IF(CONTAINS(Title, "Vice President Technology"), "CTO",
IF(CONTAINS(Title, "Information Systems"), "CTO",
IF(CONTAINS(Title, "Sales"), "Sales",
IF(CONTAINS(Title, "Human Resources"), "HR",
IF(CONTAINS(Title, "Procurement"), "Procurement", NULL))))))))))))))))))))))))))))))))
AgiAgi
Hi,

you can add this,
IF(Left(Title, 2)= "AP",  "Finance",


or this:
IF(AND(CONTAINS(Title, "AP"),NOT(CONTAINS(Title, "SAP"))),  "Finance",
Jessica EaganJessica Eagan
Worked great thank you!