Multiple IF Formula Or any suggestive formula that could work

geeklarokcmie

Good afternoon Alteryx Experts,

I have five columns as listed below and I'm looking to get the values in new columns : "Unassigned_Inactive_Assignee" and "Unassigned_Inactive_Reporter"

The formula must emit a result based on the below condition:

• when the assignee contains [X] then it should output inactive_assignee
• and when the assignee is empty then it should output unassigned_assignee
• and when the above conditions are not met it should emit the assignee name "as is"

Same goes for the Reporter.

Defect ID	Assignee	Reporter	Unassigned_Inactive_Assignee	Unassigned_Inactive_Reporter
113	John, Doe	Stevie, Doe	John, Doe	Stevie, Doe
145			Unassigned_Assignee	Unassigned_Reporter
1789	Jill, Doe	Dane, Doe [X]	Jill, Doe	Inactive_Reporter
156	Jack, Doe [X]		Inactive_Assignee	Unassigner_Reporter

Thank you in advance.

lwolfie

It would require 2 formulas.  One for each column.  For the Unassigned_Inactive_Assignee column, Use

If isempty([Assignee]) then "Unassigned_Asignee"

Elseif Contains([Assignee],"[X]") Then "Inactive_assignee"

Else [Assignee]

ENDIF

You might have to use isblank instead of empty.  It depends on how your data is set up.