Skip to first unread message

Pi R/D

unread,
Mar 29, 2015, 10:14:33 AM3/29/15
to mitappinv...@googlegroups.com
Hello,
I know how to find a word or a text in a Google sreadsheet but it's searching only on the one sheet, how to do to search on all sheets ?
Thank you
Capture3.JPG

Taifun

unread,
Mar 29, 2015, 12:38:01 PM3/29/15
to mitappinv...@googlegroups.com
most probably you have to search each sheet separately
to search a sheet separately, you probably can add the sheet number additionally in the URL unfortunately the documentation doesn't tell us something about this https://developers.google.com/chart/interactive/docs/querylanguage?hl=en#Setting_the_Query_in_the_Data_Source_URL
you have to try yourself or do a Google search
Taifun

Trying to push the limits of App Inventor! Snippets and Tutorials from Pura Vida Apps by Taifun.         

Pi R/D

unread,
Mar 30, 2015, 3:58:11 PM3/30/15
to mitappinv...@googlegroups.com
Ok thank, you.
I found this syntax: ('Example sheet'!A2:I, select A where B matches 'Eng'

Pi R/D

unread,
Mar 31, 2015, 3:32:36 PM3/31/15
to mitappinv...@googlegroups.com
I don't know why it doesn't work with app inventor but if I do that in my sheet it's working
Reply all
Reply to author
Forward
0 new messages