Search and Sort

[jwewer]

I am using the below formula in hopes that I can sort the gallery by sponsor and search the below text fields. When I put it in the gallery goes blank and I get errors on all the fields inside the gallery. Any advise thank you in advance.  

Sort(Studies,Sponsor);Search(Studies,searchboxlab_1.Text,"field_2","field_3","field_9")

[MKreusburg · Accepted solution]

Hello, you need to use te formular together.

try this.

Sort(Search(Studies,searchboxlab_1.Text,"field_2","field_3","field_9"),Sponsor)

if you need to utilize more than one formula, you need to separate them with ";;"

ex: 

Sort(Studies,Sponsor);;Search(Studies,searchboxlab_1.Text,"field_2","field_3","field_9")

[jwewer]

thank you I am brand new to this stuff and that makes perfect sense. I tried several ways but was not sure the order of items. Thank you  !