https://community.jmp.com/t5/Discussions/OR-formula/m-p/775618#M95792 <P>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.&nbsp;</P> Fri, 26 Jul 2024 11:26:57 GMT plfazeli 2024-07-26T11:26:57Z https://community.jmp.com/t5/Discussions/OR-formula/m-p/775618#M95792 <P>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.&nbsp;</P> Fri, 26 Jul 2024 11:26:57 GMT https://community.jmp.com/t5/Discussions/OR-formula/m-p/775618#M95792 plfazeli 2024-07-26T11:26:57Z https://community.jmp.com/t5/Discussions/OR-formula/m-p/775663#M95796 <P>You have to compare them one by one. Or you can utilize Contains with a list</P> <PRE><CODE class=" language-jsl">Contains(Eval List({:Column 1, :Column 2, :Column 3}), "a") &gt; 0</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1721995019918.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66524i5FF24AD074619F7C/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1721995019918.png" alt="jthi_1-1721995019918.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1721995002502.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66523i5ADC09ED026CA4D8/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1721995002502.png" alt="jthi_0-1721995002502.png" /></span></P> <P>&nbsp;</P> <P>There are also other methods</P> Fri, 26 Jul 2024 11:57:33 GMT https://community.jmp.com/t5/Discussions/OR-formula/m-p/775663#M95796 jthi 2024-07-26T11:57:33Z