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 |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |