# Google Sheets Row Owner **URL:** \ **Category:** Ask for Help\ **Created:** [September 26, 2022, 10:29pm UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232 "2022-09-26T22:29:43Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![rayo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rayo/32/91372_2.png) [@rayo](https://community.glideapps.com/u/rayo)\ **Post date:** [September 26, 2022, 10:29pm UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/1 "2022-09-26T22:29:43Z")
this could be simple, my brains is just blocked late at night I have a column in Google Sheets with words separated by a comma example 1: Admin, Main Admin, Accountant example 2: Admin example 3: _black no data_ How can I make these 3 words or 4 words or sometimes 1 word only row owners in Glide? ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [September 26, 2022, 11:04pm UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/2 "2022-09-26T23:04:53Z")
Since computed columns cannot be row owners, you will have to modify your data in your Google Sheet to be multiple columns. Name the columns something like “Owner 1” “Owner 2” “Owner 3” Owner 4" and so on. Glide will pick them up as an Array Column, and you can make that Array Column a Row Owner. You will not be able to maintain your owner columns in the data editor separately, but you should be able to set up a custom form to maintain them through Glide. ---
**Author:** ![rayo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rayo/32/91372_2.png) [@rayo](https://community.glideapps.com/u/rayo)\ **Post date:** [September 27, 2022, 5:07am UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/3 "2022-09-27T05:07:23Z")
Thank you David. Yes I’m aware of what you mentioned. I’m just confused how do I modify data in such a column. Keep in mind, although most fields have 3-4 words, there is no constant length one field can have 100 words separated by a comma. I also have tens of thousands of rows, cannot manually input them. ---
**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:** [September 27, 2022, 5:29am UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/4 "2022-09-27T05:29:19Z")
Although you will see the columns as an array in the Data Editor, you can still address the columns individually with a Set Column Values action. So you could have an Edit Form with a whole bunch of text input components, each addressing one of the Owner columns. Pretty awful, but I can’t think of a better way to do it off the top of my head. ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [September 27, 2022, 11:40am UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/5 "2022-09-27T11:40:41Z")
> [@rayo](#): > > one field can have 100 words separated by a comma. I also have tens of thousands of rows, cannot manually input them. Well, here’s where a spreadsheet expert could help. You shouldn’t have to split the fields into multiple columns manually. There’s probably a spreadsheet wizard that can do it for you. But I don’t know enough about Excel, and I know even less about Google. ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [September 27, 2022, 3:52pm UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/6 "2022-09-27T15:52:16Z")
> [@Darren\_Murphy](#): > > So you could have an Edit Form with a whole bunch of text input components, each addressing one of the Owner columns. That’s exactly how I did it in one of my apps. It really wasn’t that bad (I only had eight potential owners). It was for a genealogy, and once a relative is entered into the system, I wanted them to be sharable to other relatives who were also users of the app. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 28, 2022, 1:07am UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/7 "2022-09-28T01:07:58Z")
Here you go. Formulas are marked in light red. > **[Demo Array](https://docs.google.com/spreadsheets/d/1ZwuF-AWcavp5ymwUnjMc0z1OX2ZcBTI5Od1UtychWII/edit#gid=0)** > > Demo Array > > Row Owners,Access/Row Owner 1,Access/Row Owner 2,Access/Row Owner 3,Access/Row Owner 4,Access/Row Owner 5,Access/Row Owner 6,Access/Row Owner 7,,,,,,,,,,,, > Admin, Main Admin, Accountant,Admin,Main... ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/785062c196b34eee87b74a82da64177a69c35f2a.png) ---
**Author:** ![rayo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rayo/32/91372_2.png) [@rayo](https://community.glideapps.com/u/rayo)\ **Post date:** [September 28, 2022, 9:18am UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/8 "2022-09-28T09:18:20Z")
Thank you very much! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 28, 2022, 9:42am UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/9 "2022-09-28T09:42:11Z")
Please note that you should put these at the very right end of your data so that when it grows, it has space to grow, and you won’t accidentally put a column between the generated columns. ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [September 28, 2022, 12:26pm UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/10 "2022-09-28T12:26:10Z")
> [@ThinhDinh](#): > > [Demo Array - Google Sheets](https://docs.google.com/spreadsheets/d/1ZwuF-AWcavp5ymwUnjMc0z1OX2ZcBTI5Od1UtychWII/edit#gid=0) I really like this, @ThinhDinh! I am more of an Excel user because of circumstances (I’m old), but I am growing to enjoy working with Google Sheets also. ---
**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:** [September 28, 2022, 12:56pm UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/11 "2022-09-28T12:56:26Z")
The company I used to work for was an early adopter of GSuite in Asia back in about 2008. We pushed really hard at the time to get the whole company (about 1000 employees) off MS Office and on to GSuite. It was hard work and took the best part of a year, but once it was done we never looked back. I haven’t touched Excel since that time (or anything MS, actually), and I refuse to. I’m sure it’s a lot better than it was back then, but I’m just not interested. If somebody asks me to work with Excel, I politely say no and refer them to somebody else 🙂 ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [September 28, 2022, 1:34pm UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/12 "2022-09-28T13:34:16Z")
> [@Darren\_Murphy](#): > > If somebody asks me to work with Excel, I politely say no I don’t have that luxury! 😅 🤣 😂 ---
**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:** [September 29, 2022, 1:34pm UTC](https://community.glideapps.com/t/google-sheets-row-owner/50232/13 "2022-09-29T13:34:53Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.