# Add more users in one cell

**URL:** https://community.glideapps.com/t/add-more-users-in-one-cell/14667
**Category:** Ask for Help
**Created:** [August 25, 2020, 6:02pm UTC](https://community.glideapps.com/t/add-more-users-in-one-cell/14667 "2020-08-25T18:02:08Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Jacopo\_Chiapello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacopo_chiapello/32/222_2.png) [@Jacopo\_Chiapello](https://community.glideapps.com/u/Jacopo_Chiapello)
#### Post date: [August 25, 2020, 6:02pm UTC](https://community.glideapps.com/t/add-more-users-in-one-cell/14667/1 "2020-08-25T18:02:08Z")

</div>

Hi, i want to add more users in only one cell. I need this to filter data by users.

(if the user is in this cell he can see this data)

This cell is Dinamic, i put there one formula that take users from another sheet.

Can i do this?  
Thanks

---

<div class="post-metadata">

### 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: [August 26, 2020, 12:44am UTC](https://community.glideapps.com/t/add-more-users-in-one-cell/14667/2 "2020-08-26T00:44:55Z")

</div>

How are you putting a user into a cell currently? Is it only one user? There is a couple options:

1. Create an array of columns in your sheet (‘Email 1’, ‘Email 2’, ‘Email 3’, etc.) which will create a single array column of ‘Email’ within Glide to use for setting conditions by signed in user.

2. The possibly better option is to create a comma delimited list of emails in a single cell. Then use the New Split Texts column to split the comma delimited list into an array of emails. The use that Split Texts column to set conditions by signed in user.

---

<div class="post-metadata">

### Author: ![Jacopo\_Chiapello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacopo_chiapello/32/222_2.png) [@Jacopo\_Chiapello](https://community.glideapps.com/u/Jacopo_Chiapello)
#### Post date: [August 26, 2020, 11:41am UTC](https://community.glideapps.com/t/add-more-users-in-one-cell/14667/3 "2020-08-26T11:41:02Z")

</div>

Hi Jeff,  
thanks for your reply.  
Now i Have a trigger that puts in one cell (ISCRITTI) all user mail that i want. (comma separated).

But i have a problem whit Glide because don’t read all mail in this cel.  
I have set Visibility options like this:

-ISCRITTI-  
IS -MAIL-

where mail is user column and ISCRITTI is a cell where i have all mail that i want to show this component.

---

<div class="post-metadata">

### 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: [August 26, 2020, 1:01pm UTC](https://community.glideapps.com/t/add-more-users-in-one-cell/14667/4 "2020-08-26T13:01:24Z")

</div>

Did you try the second option I offered?

Also, you could possibly do this all within glide using a relation and lookup instead of a sheet formula. Then use the lookup array for your condition. All depends on how you are obtaining the emails and how they relate to the row you are placing them on. Building it within glide would eliminate any sheet formulas and delays and give faster response times.

---

<div class="post-metadata">

### Author: ![Jacopo\_Chiapello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacopo_chiapello/32/222_2.png) [@Jacopo\_Chiapello](https://community.glideapps.com/u/Jacopo_Chiapello)
#### Post date: [August 26, 2020, 1:36pm UTC](https://community.glideapps.com/t/add-more-users-in-one-cell/14667/5 "2020-08-26T13:36:39Z")

</div>

Sorry, but i don’t understand your options.  
I have solved whit one cell comma separated user mail.  
I set Visibility

-ISCRITTI-  
includes -MAIL-

This works for me.

Thanks
