On a Google sheets, column A has checkboxes, column C is a list of items.
Copy all the items from column C to column B but skip the destination cells that are on the same row as a checked box from column A.
No cells from column C should be skipped.
Here's the sheet with the desired result in column B:
CodePudding user response:
Another approach (tick boxes in A1:A, source list in B1:Bn):
=arrayformula(ifna(vlookup(query(reduce(,A1:index(A:A,counta(B:B) countif(A:A,true)),lambda(a,r,{a;if(r=true,,max(a) 1)})),"offset 1",0),{row(B:B),B:B},2,0)))