inconveniente con appsheet / problem with appsheet

[Pj21]

Tratare de ser especifico, estoy usando esta expresión en appsheet IF(IN("Solucionado", SELECT(Soporte[Estado Soporte], ([Seguimiento] = [_THISROW].[IDTicket]))),"Cerrado","Pendiente"), como valor inicial, considerando que esto debe ocasionar que cada vez que se detecte del lado de la tabla Soporte en el Estado Soporte un registro = "Solucionado" debe actualizarse el estado Ticket a Cerrado, pero esto sucede solo al probarlo en test de las expresiones mas no en el excel 365.

I'll try to be specific, I'm using this expression in appsheet IF(IN("Solucionado", SELECT(Soporte[Estado Soporte], ([Seguimiento] = [_THISROW].[IDTicket]))),"Cerrado","Pendiente"), as an initial value, considering that this should mean that each time a record = "Solved" is detected on the side of the Support table in the Support Status, the Ticket status must be updated to Closed, but this happens only when testing it in test the expressions but not in excel 365.

[WillowMobileSys]

Initial Value expressions, by default, execute ONLY on new rows added.   The expression does not automatically recalculate when the 'Soporte" table is changed.

If you wish this expression to automatically update on each change to the row, then place the expression in the "App Formula" property of the column.

If you wish user to be able to manually adjust this status value, leave it in the Initial Value but turn ON the "Reser on Edit" property in the column.

If you want this status to update automatically anytime the table "Soporte" is changed - such as when a new row is added or change to existing row - then either:

• an update needs to be forced onto the row referenced in your post above - not sure of that table.  You would typically do this through an action. 
• Or you could use a Virtual Column and assign it the expression in your post