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

AppSheet AppSheet Q&A
1

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.

2 Likes
2

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.

4 Likes
3

Thanks.

1 Like
4

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?