if contains([product_group],"XX") AND contains([marketing], "YY") then "XXYY" elseif contains ([product_group],"AA") AND contains([marketing], "BB") then "AABB" elseif contains ([product_group],"CC") AND contains([marketing], "DD") then "CCDD" elseif contains ([marketing], "Proj A") then "Project A" elseif contains([marketing], "Proj B") then "Project B" elseif contains([marketing], "Suppt") then "Support team" elseif contains([marketing], "ABC") AND contains([marketing], "mgmt") and contains([marketing], "ABCDE") then "CONSULTING"
elseif ([product_group])
endif
Hi @Lauramaria ,
You are missing the 'else' clause which results in this error.
Please find below a modified statement with the else.
if contains([product_group],"XX") AND contains([marketing], "YY") then "XXYY" elseif contains ([product_group],"AA") AND contains([marketing], "BB") then "AABB" elseif contains ([product_group],"CC") AND contains([marketing], "DD") then "CCDD" elseif contains ([marketing], "Proj A") then "Project A" elseif contains([marketing], "Proj B") then "Project B" elseif contains([marketing], "Suppt") then "Support team" elseif contains([marketing], "ABC") AND contains([marketing], "mgmt") and contains([marketing], "ABCDE") then "CONSULTING"
else ([product_group])
endif
Hope this helps.
Best,
Jagdeesh