# Checking if text is equal to each other and then pulling values **URL:** \ **Category:** Ask for Help\ **Created:** [October 7, 2023, 4:31am UTC](https://community.glideapps.com/t/checking-if-text-is-equal-to-each-other-and-then-pulling-values/66816 "2023-10-07T04:31:28Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![nkatglide](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nkatglide](https://community.glideapps.com/u/nkatglide)\ **Post date:** [October 7, 2023, 4:31am UTC](https://community.glideapps.com/t/checking-if-text-is-equal-to-each-other-and-then-pulling-values/66816/1 "2023-10-07T04:31:29Z")
Hello, kind of new to glide and stuck on building a feature. I have a google sheet linked to my glide, and am pulling the names of classes and their difficulty. I want to average the difficulty based on the names of the classes. In the screenshot below, as an example, I would like to average all the values of the Advanced Algebra 2, then the AP statistics, and so on. ![Screenshot 2023-10-06 at 9.30.12 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/cef9aedc86b5f5d3b068bea3396ae885679c8254.png) Thank you. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 7, 2023, 4:45am UTC](https://community.glideapps.com/t/checking-if-text-is-equal-to-each-other-and-then-pulling-values/66816/2 "2023-10-07T04:45:48Z")
- Create a multiple relation column that matches the Class name with itself. - Then add a rollup column that targets the multiple relation column, and select Average → Difficulty > **[Relations](https://www.glideapps.com/docs/automation/computed-columns/relations#multiple-relations)** > > Create relationships and link rows together. > **[Rollup Column](https://www.glideapps.com/docs/automation/computed-columns/rollup-column)** > > Perform calculations on columns, such as count, average, and sum. ---
**Author:** ![nkatglide](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nkatglide](https://community.glideapps.com/u/nkatglide)\ **Post date:** [October 7, 2023, 5:03am UTC](https://community.glideapps.com/t/checking-if-text-is-equal-to-each-other-and-then-pulling-values/66816/3 "2023-10-07T05:03:59Z")
Hello, Just wondering how to match the class name with itself? The values come up as question marks. Also was wondering if this solution allows each class to have its own average. ![Screenshot 2023-10-06 at 10.03.00 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56479c741bf6042ae5ab87f3e09b37af35142072.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 7, 2023, 5:12am UTC](https://community.glideapps.com/t/checking-if-text-is-equal-to-each-other-and-then-pulling-values/66816/4 "2023-10-07T05:12:02Z")
Ignore the question marks, they don’t mean anything other than one or more matches were found. It looks like you have the relation correctly set up. > [@nkatglide](#): > > Also was wondering if this solution allows each class to have its own average. That’s _exactly_ what it does. If that’s not the result you have, please show me how you configured the rollup column. ---
**Author:** ![nkatglide](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nkatglide](https://community.glideapps.com/u/nkatglide)\ **Post date:** [October 7, 2023, 5:26am UTC](https://community.glideapps.com/t/checking-if-text-is-equal-to-each-other-and-then-pulling-values/66816/5 "2023-10-07T05:26:08Z")
Thank you so much, the solution worked. I really appreciate it. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [October 7, 2023, 9:30am UTC](https://community.glideapps.com/t/checking-if-text-is-equal-to-each-other-and-then-pulling-values/66816/6 "2023-10-07T09:30:44Z")
> [@nkatglide](#): > > The values come up as question marks The question marks have to do with the first column all the way to the left that is being used to display the elements of the relation. If that column were a text column like RowID or Name, then those values would be displayed. You probably have a computed column or a column type that Glide is having trouble reading, so it displays question marks. Put a RowID or basic text column in first place and the question marks should disappear. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [October 14, 2023, 9:31am UTC](https://community.glideapps.com/t/checking-if-text-is-equal-to-each-other-and-then-pulling-values/66816/7 "2023-10-14T09:31:16Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.