Answer the question
In order to leave comments, you need to log in
Checkbox in google sheets with condition?
Good afternoon. Please tell me how to implement:
If there is any information in column "B", then the flag (False) should be inserted into cell "A2"?
Answer the question
In order to leave comments, you need to log in
1) In A1: =ArrayFormula(B:B<>"")
2) Select A:A
3) Insert - Checkbox
The task is not very simple, because the insertion of data validation occurs in an abnormal way. But everything works, just assign the desired validation to the results of the formulas in the cells
https://docs.google.com/spreadsheets/d/1OlbkEDvUA0...
How to copy the validation.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question