Hello all
I am trying to search a field in my dataset (from Hubspot) for a range of specific search terms. Text in the field unfortunately contains a lot of dross, so I am trying to use the CONTAINS function to search for the specific terms I need, and isolate them.
The IF function advises not to nest more than two IF's in one statement, so I am attempting to use SWITCH instead. The SWITCH instructions state that the format is as follows: ( data, case, values,[case, value],[“_default_”,value])
What I am trying to do is use the CONTAINS function inside " case,".
The formula I have come up with is: SWITCH (@Column Title, CONTAINS ( @Column Title, "Online"), "Online - Teams/Zoom", CONTAINS ( @Column Title, "F2F - Showroom 1"), "F2F - Showroom 1", CONTAINS ( @Column Title, "F2F - Showroom 2"), "F2F - Showroom 2", “_default_”, "0"). This formula is supposed to look for the terms "Online", "F2F - Showroom 1", "F2F - Showroom 2" in the column, and provide only that text as a result.
However it is returning "F2F - Showroom 2" for every field in the dataset that is not blank, regardless of content, and "0" for every field that is blank.
Could someone please advise what I am doing wrong?
