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

(Neil Turner) #1

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

(Steven Coile) #2

What have you tried so far?

(Aleksi Alkio) #3

@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.

(Neil Turner) #4

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