Help with ""Contains"" formula
Hi, I am trying to create a formula that indicates the following: IF [field 1- text multiple choice] contains "GM" AND [field 2 - text] contains "GM", display text "GM Opp/GM Agency" IF [field ...
Forum Discussion
Try this fix
If(
Contains([GM/AA Market - Opp],"GM") AND Contains([Agency/Client Market - Consolidated], "GM"), "GM Opp/Agency",
Contains([GM/AA Market - Opp], "AA") AND Contains([Agency/Client Market - Consolidated],"GM"), "GM Opp/AA Agency",
Contains([GM/AA Market - Opp], "AA"), AND Contains([Agency/Client Market - Consolidated],"AA"), "AA Opp/Agency", "NA")
If(
Contains([GM/AA Market - Opp],"GM") AND Contains([Agency/Client Market - Consolidated], "GM"), "GM Opp/Agency",
Contains([GM/AA Market - Opp], "AA") AND Contains([Agency/Client Market - Consolidated],"GM"), "GM Opp/AA Agency",
Contains([GM/AA Market - Opp], "AA"), AND Contains([Agency/Client Market - Consolidated],"AA"), "AA Opp/Agency", "NA")