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.

Capturing unnecessary items

Cherkos12
7 - Meteor

Hi -

My formula is capturing an item that i don't need in the output. I tried using the if contains formula to capture only the ones highlighted in brown but 'unqualified' is also being captured. How'd i go about creating a formula to ONLY capture 'qualified' 'SAL' and 'SQL'

 

Thanks

 

Lead_IDLead_Status
00Q3m000015AZ1HEAWMQL
00Q3m000015AchvEACQualified
00Q3m000015AQXnEAOSAL
00Q3m000015ANrLEAWSQL
00Q3m000015AHSVEA4Unqualified
1 REPLY 1
mathieuf
Alteryx
Alteryx

Hi @Cherkos12,

 

Is it what you are looking for:

 

mathieuf_0-1639135495098.png

 

Please see attached workflow

Labels