Hey team,
In a DROPDOWN column, if I have part of the same text being displayed (e.g. “LANGUAGE: EN” & “LANGUAGE: AR”), how can I use the FORMULA column to retrieve something like: if "LANGUAGE: " is > 1, say “LANGUAGES”, if not, say the actual language.
I was trying something like this:
IF(SEARCH("LANGUAGE: ",{DROPDOWN#Labels}) > 2,“LANGUAGES”,IF(SEARCH("LANGUAGE: ",{DROPDOWN#Labels}) > 0,SUBSTITUTE({DROPDOWN#Labels},“LANGUAGE: “,””),“NA”))
but unfortunately, you cannot “search” ‘more than 1/2/3’… it’s always ‘exist’ or ‘does not exist’ with “>0”
any help?