-
Allow Summary from Report Group as a metric option on dashboard
The grouping and summary feature is great and in some circumstances may replace the need to create some sheet summary fields. However, in absence of being able to use as a metric on a dashboard, unfortunately this duplication may still be required.
-
How can I align and/or centre my widgets on a Dashboard?
I have about 20 different widgets on a dashboard. I'm looking for a way to easily align selected widgets without having to count how many grid squares are between them. I'm thinking about the function in Visio or Adobe that lets you highlight a number of items and then align them by top, left, right or centre. This issue…
-
How do I display counts of all of the dropdown options used on one sheet and possibly multiple?
Long story short, I'm building a system to track pending legislation, and for each bill that posts, team members are assigned it to one (or more) categories in a CATEGORY dropdown column. I'm working on a dashboard of high-level views, and I'm trying to figure out the most efficient way to roll-up and display how many (and…
-
Support for Expand/Collapse in for a Grouped Report Embedded in a Dashboard
I have a report with groupings. Whether or not those groupings are set to be expanded or collapsed in the report, when I embed that report in a dashboard the report is fully expanded. And there is no way to collapse it in the dashboard. The expand/collapse arrows are missing. There is a Collapse Grouped Report setting in…
-
What formula to use to count all instances of a value across multiple columns.
Hello, My colleagues have set up a sheet to help them track sustainability actions in their department. They've asked me to help with setting up reports and a dashboard that summarise and calculates the types of actions across the 4 Action type columns, as well as summarising further by team. As you can see there's been an…
-
Using COUNIFS to find a partial text match in 1 cell + if another cell is filled/blank/specific text
Hi SmartSheet Community, We've created a data set that is now being utilised by stakeholders, and we are trying to set up a way in which we can monitor the completion progress. The intention is to show each stakeholder their progress via our shared dashboard Description of our desired formula; Count if "X text" appears in…
-
Best Way of Being Able to Display Data Using a Current Sheet, Archive Sheet and Summary Reports
Hello, I'm assisting some colleagues with a solution that helps track music session bookings. There are a number of summary reports set up, which the metrics are then displayed on a dashboard. It's been set up for exactly a year, but they only want the current financial year's data to be displayed. They came to me asking…
-
When are more advanced customization features coming for graphs in Dashboards?
I just realized I cannot customize the x or y axis to show more custom increments or even time series (in day by day format). I am sure this is a common request and use case and am wondering when new features might be coming to the Dashboard graphs.
-
How to change count to percentage in stack bar chart?
Hi SS Community, I have attached two stacked bar charts I created for showing status of part shipments between sites. An example of the formula I used in my supporting sheet is: =COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") If it is a formula issue, what do I need to add/change about…
-
Is it possible to share a Smartsheet Dashboard to free collaborators with just a URL link?
Hello, I'm really hoping someone can answer my question! I am trying to create a dashboard that can be accessed by non-Smartsheet users with just a link. The only option I see right now is that if you do use a link, that person must already be "shared" onto the workspace. I am trying to find a workaround so I do not have…