Hey Team,
Daft question I have 3 columns, i want check across those 3 columns if any of those columns has "Yes" then in a new column called "Outcome" then populate with value of "issue".
Input
Name Match | City Match | Country Match |
Yes | No | Yes |
No | No | No |
- | - | - |
Expected outcome
Name Match | City Match | Country Match | Outcome |
Yes | No | Yes | Issue |
No | No | No | Not Applicable |
- | - | - | Not Applicable |
Looking forward to your response
Regards
Masond3
Solved! Go to Solution.
hi @Masond3
You can use Formula tool, and create new field "Outcome" with the below expression.
IF "Yes" in ([Name Match], [City Match], [Country Match])
THEN "Issue"
ELSE "Not Applicable"
END IF