How can i make not strict request with Search row - Google Sheet

(Ефим Майсак) #1

I`m trying to get information from column “Customer” and a customer name could consist of several word so i need not strict request {{ask_a_customer_name.parsed_answer}}
How can i make a search for one word from several in customer name?

We have value customer name in the first colunm - “alfa beta gamma” ->
and if Value {{ask_a_customer_name.parsed_answer}} = “beta” ->
founded row will be in google sheet table as a result - “alfa beta gamma”.