In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

contains formula

Cherkos12
7 - Meteor

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 BOLD are the new names. how'd i go about doing that. thanks 

 

Oppty_StageOppty_Probability
Closed Lost0.00
Diagnose30.00
Business Analysis/Assessment30.00
Product Presentation60.00
Relevance60.00
Quote80.00
Inspire80.00
Negotiation90.00
Validate90.00
Contract/Agreement99.00
Enable99.00
Closing99.00
Closed Won100.00
Contracted100.00
1 REPLY 1
Luke_C
17 - Castor
17 - Castor

Hi @Cherkos12 

 

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:

 

Luke_C_0-1667149768423.png

 

 

 

 

Labels
Top Solution Authors