Dashboard linking two separate sheets to create stacked column
dbalakk
✭✭
Can link two sheets in a single dashboard to create two side by side stacked columns from two different sheets?
Tags:
Answers
-
Hi @dbalakk
The way I would do this in Smartsheet is by having a Metric sheet set up with the configuration like so:
You could use cross-sheet formulas or cell links to get the numbers from your Q1 and Q2 sheets. (For example, a SUMIFS function).
Then you can configured a stacked bar chart like so:
However this doesn't group your items together in the same way. You may want to create multiple charts next to each other instead of one chart:
I hope this helps!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives