# Refer to 2 pieces of info in one cell
**URL:** https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577
**Category:** Ask for Help
**Created:** [April 7, 2020, 6:04pm UTC](https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577 "2020-04-07T18:04:21Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@1118](https://community.glideapps.com/u/1118)
#### Post date: [April 7, 2020, 6:04pm UTC](https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577/1 "2020-04-07T18:04:21Z")
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 level.
As for now I made a relation but it works only for lessons that fit a specific grade.
Thanks!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 7, 2020, 6:53pm UTC](https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577/2 "2020-04-07T18:53:42Z")
See if this helps.
> [@In App FILTER with a Google Form Checklist](https://community.glideapps.com/t/in-app-filter-with-a-google-form-checklist/5002):
>
> 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 by any VEGAN option, but for that item, they could choose High Protein without Vegan, etc. I am using this sheet: https://docs.google.com/spreadsheets/d/1p41USD9J0WC3UlXMoBGOltWkAEwmmhCsuigtzSyJ66k/edit?usp=sharing I have several columns with several options generated by a Google Form Checklbox l…
---
### Author:  [@1118](https://community.glideapps.com/u/1118)
#### Post date: [April 7, 2020, 8:29pm UTC](https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577/3 "2020-04-07T20:29:54Z")
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…
---
### Author:  [@1118](https://community.glideapps.com/u/1118)
#### Post date: [April 9, 2020, 8:18pm UTC](https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577/4 "2020-04-09T20:18:54Z")
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 other options are sheets. The relationship rows that I’ve set are not visible.
---
### Author:  [@1118](https://community.glideapps.com/u/1118)
#### Post date: [April 9, 2020, 8:19pm UTC](https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577/5 "2020-04-09T20:19:28Z")
While in your app I see all the relationship rows:
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 9, 2020, 8:21pm UTC](https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577/6 "2020-04-09T20:21:30Z")
Make sure you are setting the Multiple checkbox on the relation.
---
### Author:  [@1118](https://community.glideapps.com/u/1118)
#### Post date: [April 9, 2020, 8:25pm UTC](https://community.glideapps.com/t/refer-to-2-pieces-of-info-in-one-cell/6577/7 "2020-04-09T20:25:16Z")
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.