Reports vs. Sheet (reporting / dashboards)
I am struggling because I have a very large SHEET that has many many data points that I have created a REPORT to create a BUDGET summary and projects for Quarterly Portfolio review(s); however, NOW I have to create a REPORT from this REPORT so I can create WIDGETS / Charts on a Dashboard; however, I know it isn't a thing or is a THING?
Others in my team have created a separate SHEET and "linked" data and each time they add new entries on the 1st SHEET they have to LINK the many fields again and again. I don't want to do that. I need to be able to use the (slimmed down) REPORT to REPORT on.
Help Article Resources
Check out the Formula Handbook template!