Can link two sheets in a single dashboard to create two side by side stacked columns from two different sheets?
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!
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.