How do I update a cell based on the value of ...

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

0 3 387
3 REPLIES 3
Top Labels in this Space