Hey can someone see if you can tell what's wrong with this formula? I want to stay that if any of these column names contains a value that is "EFV" then return the value of 1 for each row into the new column.
You have to compare them one by one. Or you can utilize Contains with a list
Contains(Eval List({:Column 1, :Column 2, :Column 3}), "a") > 0
There are also other methods