Is there a way to update a column based on an app formula without editing the row?

[Jerry_Hill]

I have a table that collects statistics from other tables using App formula(e). Looking through the documentation, I get the distinct impression that an App formula will only update on a row that has been “touched” (edited). Before I give up and resort to setting the formula(e) in the backend spreadsheet, I thought I would ask the community if my impression is correct.

[Steve · Accepted solution]

If you want the computed value stored in your spreadsheet, the row must be updated through a form or by an action to prompt the App formula recalculation.

So yes, your impression is correct.

[Jerry_Hill]

Thanks.

[Inventarios_FOO]

Steve:

If you want the computed value stored in your spreadsheet, the row must be updated through a form or by an action to prompt the App formula recalculation.

So yes, your impression is correct.

Cual seria un ejemplo para hacer la accion que realice esta tarea?