Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

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