Subject says it all :). I want to start experimenting with adding my own features and calculations to the spreadsheet and I’m wondering whether all of the Foundation sheet logic is in the cell formulas or whether there are scripts running in the background?
In the Foundation template the logic is in formulas in cells, usually hidden out to the right on the dashboards. The Foundation template doesn’t require any scripts or add-on features to generate the calculations right now.
There are definitely tradeoffs to doing it this way, namely that it can slow the sheet down when you have a very large data set.
Here is a diagram of how the data flows. Feel free to customize away