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_ID | Lead_Status |
00Q3m000015AZ1HEAW | MQL |
00Q3m000015AchvEAC | Qualified |
00Q3m000015AQXnEAO | SAL |
00Q3m000015ANrLEAW | SQL |
00Q3m000015AHSVEA4 | Unqualified |