Evaluating Clay Formula for APAC and LATAM Email Validity
Is the Clay formula below doable inside the Clay table?
(
(
{{Country Grouping}} === "APAC" &&
{{Domain Validity}} === "true" &&
{{Classify Email}}?.result?.toLowerCase() === "work email"
) ||
(
{{Country Grouping}} === "Rest of APAC" &&
{{Domain Validity}} === "true" &&
({{Classify Email}}?.result?.toLowerCase() === "work email" || {{Classify Email}}?.result?.toLowerCase() === "personal email")
) ||
(
{{Country Grouping}} === "LATAM" &&
{{Domain Validity}} === "true" &&
({{Classify Email}}?.result?.toLowerCase() === "work email" || {{Classify Email}}?.result?.toLowerCase() === "personal email") &&
{{LinkedIn Existence}} === "true"
)
) ? "Qualified" : "Trash"