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:
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. :)
Solved! Go to Solution.
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.
@lwolfie That worked like a charm. Thank you :)