I've created a process to update a multi-picklist (Cloud Name) based on some words contained in a text field (Title) - it works but due to the pick values I am getting false positive.
if(Contains([Contact].Title , "Marketing Cloud"), "Marketing Cloud;", "") +if(Contains([Contact].Title , "Commerce Cloud"), "Commerce Cloud;", "") +if(Contains([Contact].Title , "B2B Commerce Cloud"), "B2B Commerce Cloud;", "")
My problem is, if the Title Contains B2B Commerce Cloud, the process populates with both "B2B Commerce Cloud" and " Commerce Cloud". Is there a way around this?
Commerce Cloud
if the title containsB2B Commerce Cloud
?