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