Will this work if it’s pulling the text from a search box instead of a set word. Like say:
=FILTER(J3:J, ARRAYFORMULA(REGEXMATCH(J3:J, “.km.”)))
Where J3:J is a list of issues to search through
Can I replace the “.km.” with “."&H2&".”
Where H2 will be the text in the Search box.
And would this formula pull all items in the J3:J that contain the searched text into a choice option in my App that has the column with the formula set as the available choices
I essentially want a user to be able to Search a term that term would pull the items of the issues list that have that term in it and will build a choices menu that has just those items with that term as opposed to the 1,000+ list of issue options