Start Free Trial

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
Top Solution Authors