D
D
dpmain2020-12-14 17:27:59
Google Sheets
dpmain, 2020-12-14 17:27:59

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

3 answer(s)
N
Noir, 2020-12-14
@PolarBearGG

https://www.benlcollins.com/spreadsheets/google-sh...
might help)

G
Grigory Boev, 2020-12-14
@ProgrammerForever

1) In A1: =ArrayFormula(B:B<>"")
2) Select A:A
3) Insert - Checkbox

A
Alexander Ivanov, 2020-12-14
@oshliaer

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
5fd822dcee0c2639900150.png
https://docs.google.com/spreadsheets/d/1OlbkEDvUA0...
How to copy the validation.

  1. Install validation in any cell of your data
  2. Copy this cell
  3. Highlight your range of results
  4. Do a special insert - only validation

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question