# Multiple checkbox

**URL:** <https://community.glideapps.com/t/multiple-checkbox/23490>\
**Category:** Ask for Help\
**Created:** [February 26, 2021, 10:11pm UTC](https://community.glideapps.com/t/multiple-checkbox/23490 "2021-02-26T22:11:02Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 6:48am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/21 "2021-02-27T06:48:48Z")

</div>

its a sheet of google

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 6:49am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/22 "2021-02-27T06:49:45Z")

</div>

there should be no problem copy in google sheets… do not copy in glide editor, in glide you can copy only one cell

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 6:53am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/23 "2021-02-27T06:53:02Z")

</div>

but if i can give you a professional advice… keep all data in one sheet, just add a column that indicate which floor it is, you can always sort this sheet by floors to keep them together, is much easier to work on data if it is in one sheet

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 6:55am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/24 "2021-02-27T06:55:04Z")

</div>

yes I have a column that says the floor is,(Piso)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 6:56am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/25 "2021-02-27T06:56:22Z")

</div>

create another column that will just have a floor number, so it will be easy to refer to

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 6:57am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/26 "2021-02-27T06:57:44Z")

</div>

ok, thanks for the tip

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 6:58am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/27 "2021-02-27T06:58:32Z")

</div>

when you have just numbers, than is easy to sort, filter, import… than you don’t need separate sheet for each floor

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 6:59am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/28 "2021-02-27T06:59:34Z")

</div>

OK. Another question, how can I get information from other sheets, and copy it to other sheets, it’s possible?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 7:00am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/29 "2021-02-27T07:00:58Z")

</div>

if on the same spreadsheets… use FILTER formula, if on deferent… use IMPORTRANGE formula, if in Glide use reference column

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 7:04am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/30 "2021-02-27T07:04:48Z")

</div>

the reference column is RELATION right?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 7:05am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/31 "2021-02-27T07:05:01Z")

</div>

yes, for instance… if you wanna copy values from 7th floor, open a sheet call 7th floor, name one column 7th floor, and in all rows put number 7, than relate that column to source sheet with floor numbers

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 7:06am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/32 "2021-02-27T07:06:08Z")

</div>

ok but when I edit a details, it doesn’t allow me to copy the data, or in the show form

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 7:08am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/33 "2021-02-27T07:08:49Z")

</div>

edit only a source sheet, and changes will automatically appear on floor sheet

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 7:11am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/34 "2021-02-27T07:11:32Z")

</div>

you dont even need floors sheets, you can filter source sheet by floor number and only this floor will show

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 7:13am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/35 "2021-02-27T07:13:01Z")

</div>

ok and copy that same information in another row right, just changing the floor?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 7:13am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/36 "2021-02-27T07:13:57Z")

</div>

do that in google sheets not in glide

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 7:16am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/37 "2021-02-27T07:16:34Z")

</div>

ok, the last question, I have to change the status of a row after a certain time, it is possible perhaps with a script, you have some experience in that part, it has to be automatic

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 7:18am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/38 "2021-02-27T07:18:23Z")

</div>

if the values are the same , you can use find and replace function, if not… only script

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [February 27, 2021, 7:19am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/39 "2021-02-27T07:19:27Z")

</div>

for example I have 10 row’s if a column is true, I check the time that was created and I wait a while and it should only change state

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 27, 2021, 7:21am UTC](https://community.glideapps.com/t/multiple-checkbox/23490/40 "2021-02-27T07:21:55Z")

</div>

yes, you can write a scrip to check if value is true, than action, ok… i have to go… sorry

[Previous page](https://community.glideapps.com/t/multiple-checkbox/23490.md?page=1)

[Next page](https://community.glideapps.com/t/multiple-checkbox/23490.md?page=3)
