Is there a way to create a chart based on a multi-select column, but display only certain tags from that column? The specific case - I have an x-axis that is based on a multi-select column “Territory Availability” with 245 possible tags representing ...
I’m trying to create a formula that can search a column that contains multiple text dates and return only the earliest date.
My {Launching} column is a text field that contains many launch dates, as well as region codes for what the date applies to l...
I used this formula in conjunction with a series of if(find()) statements. The if(find()) statement searches a multiple select field with 245 for 25 specific options.
IF(FIND(“US”, {Availability}), "US, ", “”) &
IF(FIND(“CA”, {Availability}), "CA, ",...
In this case, the reason I didn’t use OR is because I needed to search the text field and return only one value. With OR it would return every value that it found that matched, where as I was only interested in finding the FIRST value that returned a...
I managed to find the column on nested If statements and worked this out for myself. For anyone else who is curious the correct formula looks like this:
IF(SEARCH(": 02/", {Launching}), “2Feb”,
IF(SEARCH(": 03/", {Launching}), “3Mar”,
IF(SEARCH(": 0...
