I have a form feeding a master spread sheet. From that master spreadsheet I
want to import specific rows to other spreadsheets based on a single column
cell. The column is age and the spreadsheets to feed are for age groups. The
form field is type your age.This it what I am using to import rows for groups
0-2 and group 12-18.
=query(importrange("key","Youth Master List!B2:Q1000"),where col3 <=2")
=query(importrange("key","Youth Master List!B2:Q1000"),where col3 >=12")
The problem I am having is bringing info in for a group age range of 3-4 and
also 5-11. I can't seem to figure out how to get the "where" to target these
other age ranges.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/a1c1aacc-66ea-42da-a21b-b1a3c357046d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
