-
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.
-
How to use project status report and templates
Hi, I'm still new to ss and how to use free downloads! I'm stuck on how to use the Weekly Project Status Report Template like its shown in the image marked "report layout". I downloaded the template to which I have to complete the data (ref. image- "template layout". The issue is that I'm missing a key step to convert the…
-
Multi-dashboards, with same names, using single sheet summary
I am attempting to create 2 separate dashboards, for 2 different regions, from a single Smartsheet, using Sheet Summary. I can not seem to figure out how to name the summary fields the same or conversely alter the names once they are in the separate report and/or dashboard. Does anyone know a workaround for this? I would…
