- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
OR formula
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.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: OR formula
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
-Jarmo