topic contains formula in General Discussions https://community.alteryx.com/t5/General-Discussions/contains-formula/m-p/1024442#M7355 <P>recently our opportunity stage names changed in salesforce and I'd like to create a formula in alteryx to reflect the changes into the new oppty stage names based on the probability %. The ones in <STRONG>BOLD</STRONG> are the new names. how'd i go about doing that. thanks&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Oppty_Stage</TD><TD>Oppty_Probability</TD></TR><TR><TD><STRONG>Closed Lost</STRONG></TD><TD><STRONG>0.00</STRONG></TD></TR><TR><TD><STRONG>Diagnose</STRONG></TD><TD><STRONG>30.00</STRONG></TD></TR><TR><TD>Business Analysis/Assessment</TD><TD>30.00</TD></TR><TR><TD>Product Presentation</TD><TD>60.00</TD></TR><TR><TD><STRONG>Relevance</STRONG></TD><TD><STRONG>60.00</STRONG></TD></TR><TR><TD>Quote</TD><TD>80.00</TD></TR><TR><TD><STRONG>Inspire</STRONG></TD><TD><STRONG>80.00</STRONG></TD></TR><TR><TD>Negotiation</TD><TD>90.00</TD></TR><TR><TD><STRONG>Validate</STRONG></TD><TD><STRONG>90.00</STRONG></TD></TR><TR><TD>Contract/Agreement</TD><TD>99.00</TD></TR><TR><TD><STRONG>Enable</STRONG></TD><TD><STRONG>99.00</STRONG></TD></TR><TR><TD>Closing</TD><TD>99.00</TD></TR><TR><TD>Closed Won</TD><TD>100.00</TD></TR><TR><TD><STRONG>Contracted</STRONG></TD><TD><STRONG>100.00</STRONG></TD></TR></TBODY></TABLE> Fri, 28 Oct 2022 20:07:19 GMT Cherkos12 2022-10-28T20:07:19Z contains formula https://community.alteryx.com/t5/General-Discussions/contains-formula/m-p/1024442#M7355 <P>recently our opportunity stage names changed in salesforce and I'd like to create a formula in alteryx to reflect the changes into the new oppty stage names based on the probability %. The ones in <STRONG>BOLD</STRONG> are the new names. how'd i go about doing that. thanks&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Oppty_Stage</TD><TD>Oppty_Probability</TD></TR><TR><TD><STRONG>Closed Lost</STRONG></TD><TD><STRONG>0.00</STRONG></TD></TR><TR><TD><STRONG>Diagnose</STRONG></TD><TD><STRONG>30.00</STRONG></TD></TR><TR><TD>Business Analysis/Assessment</TD><TD>30.00</TD></TR><TR><TD>Product Presentation</TD><TD>60.00</TD></TR><TR><TD><STRONG>Relevance</STRONG></TD><TD><STRONG>60.00</STRONG></TD></TR><TR><TD>Quote</TD><TD>80.00</TD></TR><TR><TD><STRONG>Inspire</STRONG></TD><TD><STRONG>80.00</STRONG></TD></TR><TR><TD>Negotiation</TD><TD>90.00</TD></TR><TR><TD><STRONG>Validate</STRONG></TD><TD><STRONG>90.00</STRONG></TD></TR><TR><TD>Contract/Agreement</TD><TD>99.00</TD></TR><TR><TD><STRONG>Enable</STRONG></TD><TD><STRONG>99.00</STRONG></TD></TR><TR><TD>Closing</TD><TD>99.00</TD></TR><TR><TD>Closed Won</TD><TD>100.00</TD></TR><TR><TD><STRONG>Contracted</STRONG></TD><TD><STRONG>100.00</STRONG></TD></TR></TBODY></TABLE> Fri, 28 Oct 2022 20:07:19 GMT https://community.alteryx.com/t5/General-Discussions/contains-formula/m-p/1024442#M7355 Cherkos12 2022-10-28T20:07:19Z Re: contains formula https://community.alteryx.com/t5/General-Discussions/contains-formula/m-p/1024805#M7361 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/259511">@Cherkos12</a>&nbsp;</P><P>&nbsp;</P><P>There's no way to tell alteryx to look for bold formatting. Your best bet would be to have a table of old and new stage names and join it up:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Luke_C_0-1667149768423.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/265674iA1ADA73704302D05/image-size/medium?v=v2&amp;px=400" role="button" title="Luke_C_0-1667149768423.png" alt="Luke_C_0-1667149768423.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 30 Oct 2022 17:09:36 GMT https://community.alteryx.com/t5/General-Discussions/contains-formula/m-p/1024805#M7361 Luke_C 2022-10-30T17:09:36Z