In Google docs (spreadsheet) under Filter View, I am trying to write a custom formula for multiple conditions. For example, in column O, I may have "Jury Room" and also "Jury Rooms" and so I am trying to filter for anything beginning with just "Jury." Under the predefined conditions there is "Text Starts With" which would serve my purpose but I also want to search for other items in the same filter condition.
You can do this with a regexmatch function using the
custom formula option under the filter by condition options instead of
in regexes: the
^ means beginning of string/line and the
| is the
OR operator for regexes