I am trying to make a custom column by using an if() statement to pass an existing column through more than one text.Contains condition, and then return a string.
I have tried the below with no luck:
if text.Contains([Product], "AB") & text.Contains([Product], "CD") then "EF"
if text.Contains([Product], "AB" & "CD") then "EF"
I've found similar questions online but all of the resources I can find are using ><= and integers or are just for a single condition.
Any help on a solution would be much appreciated.
Thanks in advance!