Vertical display of current data on Dashboard w/ Checkbox
Need help finding a way to display data the way stakeholders want to see it on a dashboard.
A vendor of ours updates a SmartSheet daily with updated information (16 total columns). We want the most recent daily data to display on the dashboard so I have setup a checkbox. The stakeholders want to see some of the data vertically and other data as widgets. Reading other threads, it sounds like I need an INDEX/MATCH arrangement in another sheet to bring in data if the row with the checkbox is checked.
Data Example (truncated to show less columns)
Dashboard Example (vertical display)
Once I get the rollup sheet complete, I'm hoping it will easy to highlight specific cells that contain more detail but the vertical view is beyond my current tinkering knowledge WITH a checkbox.
Could anyone provide advice? Thank you in advance!
I have found similar threads but nothing quite detailing the steps for this.
Help Article Resources
Check out the Formula Handbook template!