I am using fantastic
Arrayformula to populate a grid in a Google Sheet:
The following is being used in each column:
=arrayformula(if(Z2:Z <> "","■",""))
Now there are some cases where the marking "square" could be inserted manually, however this will break the Arrayformula as it cannot overwrite.
How could I achieve this?