-
Question about series behavior in dashboard
Hey everybody, Right now, if I click on an individual series on my dashboard, it will hide it on the graph (like in the nephrology example below). Is it possible to change the series settings so that when someone clicks on an option (such as nephrology), it will only show that particular series and hide everything else? I…
-
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 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…
-
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…
-
Risk Matrix widget
How about providing a widget that'd plot the risks defined on a risk list to a likehood-impact matrix based on the scoring on the list? Perhaps also illustrate the latest changes in the scoring with arrows.
