A dashboard that changes with a list
Pick an item from a list and the dashboard numbers change by themselves.
This is the trick behind the coolest dashboards: a choice cell with a drop-down list, and formulas that use whatever was chosen.
Module: Cards and dashboards. Lesson 55 of 62.