ArrayFormula to apply checklist cell

Ask for Help
1

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
form-data655×546 178 KB

2

Put this in B1:

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

3

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

4

@FeAle - did this work for you?

5

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

array-formula
array-formula1366×705 437 KB

6

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
if-then-glide1366×676 241 KB

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
if-then-Google1366×696 436 KB

Thanks a lot any help

All the best

7

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.

8

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