Put formulas in a calculation sheet or in source sheet?
I just want to make sure the following scenario doesn’t have any issues - searched around but wasn’t conclusive...should I expect the dashboard to always be current in the following scenario?
- Forms bring user data into a sheet.
- A calculation sheet looks for daily totals using the Today function (among other things) for various items, as well as sums up historical entries
- Dashboard displays data from both the source sheet and calculation sheet in charts/graphs, etc.
If no one actually opens up the source sheet or calculation sheets, will the dashboard always show the most current data? (not concerned with the 10 minute refresh rate)