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