Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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