How do I update a cell based on the value of another cell?
I would like to set the value a cell to true when another cell in the same row is filled but am at a bit of a loss to do it.
I also want to be able to set the value of the true/false cell manually too
so the formula would be
if the subject text cell isnโt blank
set the target (true/false) cell to true
otherwise leave it as it is
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |