Initial value / Data action not working

Hey guys
I'm pretty new at this. I've been trying to performe an action that sums 2 other columns of the row. The triggering is ok, I see it in the monitor. However, when I set the data action [column1] to be [column2]+[column3], it doesnt perform it automatically (it tells me it's been successful in the monitor, but nothing changes). The strange thing is that, if I press the action button, it performs the action, even though the value is blank in the sheet (but you can see it when you click on it or export the tabel to SPSS or something like that).
I've tryied setting this expression to the initial value of [colum1], but it doesn't work either.  If a create a virtual column and set the same expression, it works fine (but I need that value in my sheet, so it pretty much has no use for me).
My sheet is actually a sheet generated via Google Forms, and [column1] is not one of the fields in the form.
I only have one sheet, but my primary key is set as a data stamp from the form, if that matters.

Anyone can help me?
Thanks in advance

0 3 101
3 REPLIES 3
Top Labels in this Space