Understanding "Formula Recalculation on Related Records Failed" and How to Resolve It?

If you enable "Recalculate all formulas on related sheets" under Form Settings > Form Settings in Design Mode, saving a record will trigger formula recalculations for all associated records in related sheets. For more details, please refer here.

To maintain system performance, the number of related records that can be recalculated is limited to 1000. If the number of records to be recalculated exceeds this limit, none of the related records will be recalculated, and the system will display a notification in the lower-left corner: "Formula Recalculation on Related Records Failed (Related records exceed recalculation limit)".

How to Resolve This Situation?

1. To ensure all related records are recalculated, you can manually execute the Formula Recalculation in the related sheets.

2. If you frequently reach the recalculation limit and manual recalculation is not ideal, you can disable the "Recalculate all formulas on related sheets" option and set up a Daily Workflow to recalculate formulas daily.