# Can I Use Split Text Relation **URL:** \ **Category:** Ask for Help\ **Created:** [October 8, 2020, 12:57pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915 "2020-10-08T12:57:31Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Bahadir\_Kaya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bahadir_kaya/32/14065_2.png) [@Bahadir\_Kaya](https://community.glideapps.com/u/Bahadir_Kaya)\ **Post date:** [October 8, 2020, 12:57pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/1 "2020-10-08T12:57:31Z")
Hello I have 1 column that shows users interest For example Name → Interests Bahadır → Basketball, Yoga, Camping, Books Marie → Football, Yoga, Dance, Movies Justin → Basketball, Books, movies, football I want to make a relation percantage for example harmony of Justin and Marie is %50 (Football, Movies) Bahadir - Marie has %25 (Only Yoga) When someone look profile he can see harmony percantage between user and profile ---
**Author:** ![PaulVu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulvu/32/14973_2.png) [@PaulVu](https://community.glideapps.com/u/PaulVu)\ **Post date:** [October 8, 2020, 1:17pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/2 "2020-10-08T13:17:19Z")
I think you can use =(COUNTIF(Basketball-football, “true” ))/(total number of Interests) ---
**Author:** ![Bahadir\_Kaya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bahadir_kaya/32/14065_2.png) [@Bahadir\_Kaya](https://community.glideapps.com/u/Bahadir_Kaya)\ **Post date:** [October 8, 2020, 1:19pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/3 "2020-10-08T13:19:11Z")
But split text will not exist on google sheets ---
**Author:** ![PaulVu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulvu/32/14973_2.png) [@PaulVu](https://community.glideapps.com/u/PaulVu)\ **Post date:** [October 8, 2020, 1:20pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/4 "2020-10-08T13:20:25Z")
can you share your data table? ---
**Author:** ![Bahadir\_Kaya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bahadir_kaya/32/14065_2.png) [@Bahadir\_Kaya](https://community.glideapps.com/u/Bahadir_Kaya)\ **Post date:** [October 8, 2020, 1:22pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/5 "2020-10-08T13:22:42Z")
I will do and send 🙂 I tried yesterday and deleted project. I create from zero ---
**Author:** ![PaulVu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulvu/32/14973_2.png) [@PaulVu](https://community.glideapps.com/u/PaulVu)\ **Post date:** [October 8, 2020, 1:29pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/6 "2020-10-08T13:29:54Z")
Let’s me build a simple for you ---
**Author:** ![PaulVu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulvu/32/14973_2.png) [@PaulVu](https://community.glideapps.com/u/PaulVu)\ **Post date:** [October 8, 2020, 1:39pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/7 "2020-10-08T13:39:55Z")
![Screen Shot 2020-10-08 at 8.39.20 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/987af605a5db91851a785e8ee67775c3369bae9a.png) Is it true? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 9, 2020, 1:46pm UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/8 "2020-10-09T13:46:37Z")
I think this would only work within Glide if you have a sheet with Names and another sheet with name and interest listed on separate rows. - Create a relation between the Name sheet and Name/Interest sheet using name. - Using that relation, create a rollup to get a total count of all interests for each name. - In both sheets, create a template column that contains the Name, joined with the user profile name, so the name of each user is joined with the signed in user on each row. - Bahadir - Bahadir - Marie - Bahadir - Justin - Bahadir - In the Name/Interest sheet, create a relation that links the interest to each interest in the same sheet. - Using that relation, create a lookup to get an array list of of the joined names (Marie - Bahadir) that contains the same that interest. - In the Name sheet, create another relation that links the joined names template value to the lookup of joined names in the Name/Interest sheet. This should give you a list of rows of matching interests between both users. - Using that relation, create a rollup to get a total count of all matching interests. - Now divide the total count of matching interests by the count of total interests and that should give you the percentage. ---
**Author:** ![Bahadir\_Kaya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bahadir_kaya/32/14065_2.png) [@Bahadir\_Kaya](https://community.glideapps.com/u/Bahadir_Kaya)\ **Post date:** [October 12, 2020, 10:56am UTC](https://community.glideapps.com/t/can-i-use-split-text-relation/16915/9 "2020-10-12T10:56:01Z")
I solved this issue via make 4 chooice component and 4 column. I think it is ok. I love glide because you can always a way to do something 🙂