-
Display chart that shows no. of tasks assigned to each person based on priority
I created a report that is grouped by 'Assigned To' and then 'Priority'. I also have summarize on for both columns. I want to chart this data in stacked columns on my dashboard to show the no. of tasks that are assigned to each person based on priority. Ex. Bob is assigned 3 High priority tasks, 2 medium tasks, and 4 Low…
-
Displaying metric sheet info
Anyone know of a way to display metric sheet data like this in my dashboard in the same exact format? If I had a way I could mirror this same exact screenshot that would be great. I have been messing around with the widgets but cant get a way to display it exactly like this.
-
Formula to return a number of values that have entered in the last X amount of days
I'm looking for formula help to get me to an end point on a dashboard that would look something like this… Not sure if a report or metric sheet would be best way to get to this point (I prefer a metric sheet if possible) I have a sheet that is collecting the names of these units as well as the date the info was submitted.…
-
Dashboard Graph Help
Wondering If it is possible for the second graph on this page to act like the first one where the line is cut of in the month we are in. So, is it possible to make the the lines stop in June instead of trailing off into July? Maybe an easy fix in my metric sheet? Thanks.
-
Very certified professional, looking for a Contractor.
I am writing to express my enthusiastic interest in a Smartsheet Developer position. As a highly skilled developer with expertise in web and application development using Flutter, I am confident in my ability to contribute effectively to your team. My strong capabilities in database integration and a comprehensive…
-
Checkbox Used as Input in Dashboard
Has anyone ever used a checkbox input from a dashboard in a formula to include/exclude certain data in a calculation for the dashboard? I currently have a dashboard where I ask the user to input a date range that would be used to parse all of the data that could be shown in a dashboard to only the data in a date range.…
-
How can I export Schedule view?
I am looking to create a custom dashboard that does not seem feasible with the current filtering options available in People or Project view under Schedule. Is there a way to export resource bookings in Schedule?
-
Selected data cannot be charted - shouldn't be happening
I have a report that I want to use as a data source for a chart on a dashboard. The report has summaries and the required grouping so that the top-level row of data can be used for the chart. Even though there clearly is numerical data for a chart to be created (see below), I am getting the error - "Selected data cannot be…
-
NEW! Dashboard chart quality-of-life enhancements
Hi Community! We’ve released quality-of-life enhancements for charts, focused on improving their visual quality and readability. Now, chart axes extend just enough to accommodate values over 100%, eliminating unnecessary white space. Additionally, data labels in stacked bar and column charts will scale to fit neatly within…
-
Resource Management Schedule view by department
Hello, Is it possible to get projects grouped by department like in the attached picture? I don't see where there's an option to sort by department, and from my understanding using tags for projects (i.e. creating a "Marketing Department" tag and attaching to appropriate projects) doesn't consolidate them as nicely. For…