# ArrayFormula to apply checklist cell

**URL:** <https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797>\
**Category:** Ask for Help\
**Created:** [July 19, 2020, 9:03pm UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797 "2020-07-19T21:03:22Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![FeAle](https://avatars.discourse-cdn.com/v4/letter/f/5f8ce5/32.png) [@FeAle](https://community.glideapps.com/u/FeAle)\
**Post date:** [July 19, 2020, 9:03pm UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797/1 "2020-07-19T21:03:23Z")

</div>

Hi, Please

I would like to apply a checklits cell data always I create a new data in column A.

I have tried this formula - =ARRAYFORMULA(if(A2:A\<\>“”;B2:B=FALSE;)), but without success.

Any tip? See attached the image from table

 ![form-data](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b880a06356b5d42273393524c19ec2f89ddc34ba.jpeg)

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [July 19, 2020, 10:16pm UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797/2 "2020-07-19T22:16:40Z")

</div>

Put this in B1:

={“Reservado”;ARRAYFORMULA(IF(A2:A\<\>"",TRUE,””))}

---

<div class="post-metadata">

**Author:** ![Coupons\_Deal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/coupons_deal/32/9734_2.png) [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)\
**Post date:** [July 19, 2020, 10:16pm UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797/3 "2020-07-19T22:16:47Z")

</div>

You can do this via If-Then-Else feature.  
Check it here

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/37c88684da20a8851ec772104f73c942f7684da5.jpeg "If → Then → Else Column | Glide Data Editor Tutorial") ](https://www.youtube.com/watch?v=W-hsgR0qyzs)

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [July 20, 2020, 4:29pm UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797/4 "2020-07-20T16:29:07Z")

</div>

@FeAle - did this work for you?

---

<div class="post-metadata">

**Author:** ![FeAle](https://avatars.discourse-cdn.com/v4/letter/f/5f8ce5/32.png) [@FeAle](https://community.glideapps.com/u/FeAle)\
**Post date:** [July 25, 2020, 1:07am UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797/5 "2020-07-25T01:07:05Z")

</div>

Hi,  
Sorry my late and thanks a lot for reply, but the google sheet return an error yet

 ![array-formula](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d5634516e9503724e65d318cfd03697a07b0cc3a.jpeg)

---

<div class="post-metadata">

**Author:** ![FeAle](https://avatars.discourse-cdn.com/v4/letter/f/5f8ce5/32.png) [@FeAle](https://community.glideapps.com/u/FeAle)\
**Post date:** [July 25, 2020, 1:17am UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797/6 "2020-07-25T01:17:05Z")

</div>

Hi,

Thanks a lot for the replay.

With If/Then I did apply a new column in Glide sheet and new when I have a new data, the Boolean Reservado Column is checked automatically.

 ![if-then-glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/85cf82ed1511f4fbcd346e02024df9c1300fe5d8.jpeg)

But the Google Sheet continuous the same. The changes applied in Glide Sheet didn’t update in Google Sheet. Maybe I need to apply this (or similar) conditions directly in Google Sheet.

 ![if-then-Google](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3d78cc8d513b768344fd87f3276d4e3e4d445929.jpeg)

Thanks a lot any help

All the best

---

<div class="post-metadata">

**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:** [July 25, 2020, 1:23am UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797/7 "2020-07-25T01:23:36Z")

</div>

Go to Data \> Data Validation, apply checkbox settings to the range C2:C. It will automatically apply to new rows, but delete the empty ones first so it won’t affect your row count.

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [July 25, 2020, 7:31am UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797/8 "2020-07-25T07:31:14Z")

</div>

Remove content C2:C17 as the ARRAYFORMULA is trying to overwrite it