-
How do I add horizontal lines to a stack chart for my Dashboard?
I need to add 2 horizontal lines to my stack chart to show when we have over allocated for our resources and where our average is. Does anyone know how to make this happen in a Smartsheet dashboard?
-
starting out
I have no idea how to start the program. I need the basics on how to build charts and graphs.
-
Timeline Reports - Removing Uncategorized Group
How can you get rid of the uncategorized land in a report timeline view?
-
Gantt Chart View in Reports
Please help! I understand that we can't customize the gantt chart bars anymore if it is a parent row but why am I getting random colors on the bar view in my report? I would prefer it remain grey. The first picture is the Smartsheet and the second one is the report pulling from the sheet.
-
How to include alpha information in a summarized report
Hello, I have a report that summarizes all hours spent on a particular phase. Is there any way to include the missing information? I need to create a condensed report to add to a dashboard. Missing information: Site Name, Turbine Number, Blade Number, Date Performed, & Current Phase
-
Streamlining Automation Requests/Form Options
My team is looking to use Smartsheet capabilities as we continue building an dashboard for tracking KPIs across various project initiatives. Each initiative has its own row in Smartsheet, and we've included the initiative owner in the corresponding column. Some initiative owners are listed for multiple initiatives. We're…
-
Reporting by month
Hello! I'm creating a reporting dashboard from a Smartsheet that tracks all incoming project types and I'm hoping to report a breakdown of the number of projects that are due each month. Is this possible with a particular formula? I'm coming up with a lot of errors. Thank you!
-
Merged: Data Shuttle link to "Push" manually from Report to run Data Shuttle from a sheet field or Dashboard Button
This discussion has been merged.
-
Merged: Multiple reports into a graph with trend line
This discussion has been merged.
-
Save a Dashboard Theme to be used across all Users as a company standard
Does Smartsheet have any thoughts of being able to save Dashboard Themes similar to how we can set standard Colors, Logos, etc.? As a company standard, we would like for all Users to use a standard Dashboard Theme, but currently, this needs to be Imported into all new Dashboards. The best solution at the moment appears to…
-
Automating Monthly Bar Chart Updates - Is There a Better Way?
I have a bar chart on an executive dashboard showing intakes assigned and completed by month and the bars are side by side instead of individual widgets for assigned and completed each month. Currently my process is: Add two new hardcoded COUNTIFS summary fields in my sheet summary each month (Month Assigned, Month…
-
Are there resources that can support with making custom dashboards?
I work in real estate and I want to build a custom dashboard/template to track where we are at with deals. The pre-made templates are all too specific and hard to use. I've created my own sheet/intake form but am looking for support on building the dashboard and how information is shown.
-
Updated Graph Options (Fuel-Gauge or Tachometer)
I've searched the community and did see one mention of fuel-gauge stile charts/graphs back in 2023, but nothing specific. My company's leadership is, for lack of a better word, enamored with the visual of a gauge style graph. Is there any plan to make this an option? or is there instructions on how to create one within…
-
Best Practice - How to introduce a new dashboard that will replace existing dashboards across multiple projects
History: Our PM's have redesigned a dashboard (status report) that replaces our current dashboard format used across all our projects. Problem: I need to figure out how to replace our current dashboard (and supporting Sheet) with minimal effort. We have a Template Library (Control Center users) so both the sheet &…
-
Timeline widget in Smartsheet is taking the wrong date
Hi all, I am creating a dashboard make the cutover dates for parts more visual for the stakeholder. My smartsheet has two columns with dates. Last Update CutOver Date The timeline widget is always taking the "Last Update" for showing the part in the timeline widget, but I need the CutOver date. Do you know, how to adjust…
-
Dashboard not showing all information
I have a report that is showing tasks with their end dates and I have a filter to show only those tasks where the end date is overdue or due in the next 14 days. This works fine in the report however in my dashboard (using report widget) the end dates for the overdue tasks are showing fine but the end dates for the tasks…
-
Unable to see all of the milestones in a project.
I am unable to see all of the milestones in the Project Tracking Rollup Dashboard. Why is this happening, and can you help me fix this? Are there any articles that can help me understand this?
-
Column taking up half of the view in a section of the Dashboard.
Can you help me figure out why the % Complete column is taking up half of the view in the ‘At Risk Tasks’ section of the Dashboard? Are there any articles that explain how to modify this?
-
Edit Access Not Working
Hi, In My Smartsheet, i have given the edit access to some of the people to sheet. But suddenly all of them are unable to edit means they lost edit access. Even though there permission in Editor can Share
-
Can I create dashboards across workspaces
Am I able to create a dashboard, aggregating projects across multiple workspaces? My team is currently building a dashboard, but our projects aren't on the same workspaces, and don't have the same user permissions for all.