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
What have you tried so far?
@Neil_Turner Iโm afraid you canโt do that directly with the If expression if you are using a normal column. The problem is the โleave it as it is.โ What you could doโฆ you can overwrite the existing value with โTRUEโ but you need to do that with an Event action when you save the form. If the cell is not blank, trigger the Event action and update the field. If itโs blank, donโt trigger that action.
I tried using a workflow but all I seem to be able to do on an update is delete Iโve tried the spreadsheet formula in the columns panel and on the spreadsheet itself
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |