I have a sheet where the user can update values on other sheets through a subtable. Is there a way to trigger the formulas to re-calculate on each sheet that has been changed through the subtable?
We do have a setting about triggering recalculation on parent or related sheets, which please refer to this article:Formulas
If it doesn’t meet all your expectation, maybe we need to see the structure so that we could have a better understanding and give you some suggestion. You could do so by sending a support ticket via “Need Help” with your needs and which part didn’t work as expected and grant Ragic Support access to your database.
Thanks so much, works great. Now I just need to make sure that I don’t cascade too many sheet re-calculations and bog down the system