I have a condition where I need to check if my multi-select field has one specific option selected (along with other options) and if so, I need to show another text field. I thought of doing it using studio formula by making text field dependent but I am not able to find a way on how to check if my multi-select field has that specific option selected.
For example: I have Industry as multi-select with options - Manufacturing, Technology, Food, Textile and I want to show text field if Industry field contains "Textile" as one of the options. How to achieve this using Studio formula. I tried using toString($industry) by converting the field value to string and use substring but no luck.
Any help would be greatly appreciated.