-
How to display numbers correct in a stacked column in a dashboard?
Hi all when I am creating dashboards and using the "stacked Column" with a couple of values - the display is always confusing the customer. The number per value is displayed ABOVE the connected layer instead of inside the connected layer - here an example: This is it today with the number always above the appropriate…
-
How to count tasks across all sheets in a workspace
I have a master metrics sheet that I am using. I'd like to be able to count tasks by assigned to across all sheets in a workspace. The goal is to have this formula work if/when any new sheet is added to the workspace. Reports are not really working for me because my assigned to column is a multi-select column. I don't see…
-
How to track time in status?
I have a status column used for the tasks on projects. I'd like to track how long a task (row) stays in a particular status (e.g. in progress). I'm not quite sure how I would get this data.
-
Enhancement request - Series Behavior on Dashboard
Hey everybody, Right now, the series categories on dashboard graphs can only be toggled on and off (like nephrology below). I was wondering if an enhancement could be made so that when someone clicks on a specific category (such as nephrology), it will only show that particular series category and hide everything else.…
-
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…
