Hi. I have a sheet that collects data from a google form. One row can get more than one answer (checkboxes) so that row’s cells contain more than one piece of information. Is there a way to make a relation that would pull that data? It is a list of lessons and some of them fit more than one grade…

See if this helps. [image] In App FILTER with a Google Form Checklist I was wondering how we could use the In APP Filter on a column used on a column generated by a GOOGLE FORM CHECKBOX question. I saw the post about VEGAN options (2/19) So I want the row to be chosen …

Thanks! I’m afraid it didn’t help, because my form is dynamic and people keep submitting lessons. Splitting the data into the second sheet would’t be automatic…

Well, I was wrong. I see now that the function you mentioned does work automatically when new data arrives. Great. But I didn’t figure out how to end it all well. I try to add an inline list but I don’t see data from the new rows. When configuring the list I see only one relationshup row and the …

While in your app I see all the relationship rows: [image]

Make sure you are setting the Multiple checkbox on the relation.

I did. Apparently I mixed the other sheets (I’ve 4 of them. data. your function. teachers and age groups) and now it seems to be solved! Thank you very much.

Refer to 2 pieces of info in one cell

Ask for Help

Jeff_Hager April 7, 2020, 6:53pm 2

See if this helps.

Topic		Replies	Views
In App FILTER with a Google Form Checklist Ask for Help	3	864	February 28, 2020
Replicate a Relation Column in Google Sheet Ask for Help	19	1132	October 5, 2021
Relation in Form is not working Ask for Help	3	205	February 7, 2024
Link two checkboxes from different sheets Ask for Help	29	1420	June 1, 2020
Relation inside a relation, inside a relation Feature Requests	9	775	December 23, 2019

Refer to 2 pieces of info in one cell

Related topics