Hi team,

·

Hi team, Can you please help me develop this formula https://www.loom.com/share/d507cce2182e4400ac7aae8eeb0108a8?sid=fdd4437e-f2fa-4200-82fa-7cfacacda907 https://app.clay.com/workspaces/95273/tables/t_G2eycvfECtyO/views/gv_WgULhEcw2UZe !{{Lookup Contact}}?.foundAtLeastOne || ( {{Lookup Contact}}?.records?.[1]?.Lead_Status__c != "SQO" && {{Lookup Contact}}?.records?.[1]?.Lead_Status__c != "SQL" && {{Lookup Contact}}?.records?.[1]?.Lead_Status__c != "Customer" )

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Avery
·
Yep! Parentheses do group conditions.
Avery
·
You'll have an easier time of things breaking this up into a couple of columns that do less work each. Like you could have a checkbox that's just checking that col is
"{{status_column}} == "Customer || {{status_column}} == "NQL" || {{status_column}} == "SQL"}}
Clay Team
APP
·
Hey Tyron, taking a look! Avery is familiar with formulas so that may be the way to go!

·

to your original question conditions work like this:

true || false == true
false || (true || false) == true
false || (true && false) == false
true && false == false
true && (false || true) == true