-
Dashboard Metric Widget White Space
I'm working with a metric widget in a dashboard and I'd like to minimize the amount of white space that appears between the label and the data/information presented. If I make the widget narrower the white space decreases but then there isn't sufficient space or the information that needs to be presented. Is there any…
-
Can't plot data eventhough I have access
Hello, I have troubles plotting the data of a certain smartsheet. I tried copying it from the smartsheet as well as recreating the chart from scratch. Nothing seems to work. Any ideas? Data source is a filtered report.
-
Sheet Summary Report with Dropdown
I'm creating a sheet summary report to use for a dashboard and have my source data broken out by phases. I'd like to be able to group the report data by phase, so I tried adding a single selection dropdown to the sheet summary. However, it's returning blank in the report. The source data is a project management / Gantt…
-
Dashboard- weekly project status submissions
Hi, I would like to create a monthly dashboard that displays which project managers have submitted their status each week. I have a master Project Management Sheet where project managers submit their status. I plan to have an automation that clears whatever the project manager has added , in order to make room for their…
-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…
-
Smartsheet report cell linking not working
Hello, I am trying to edit a Smartsheet report to update a dashboard and cannot get the content to populate. I linked the correct cells into a summary sheet called Portfolio and the data is populating correctly. But when I go to pull in a specific column data from Portfolio to the report sheet called Report, the column…
-
Dashboard chart from a report
I have a report which collects data from multiple sheets - this includes project health using RYG status. I would like to add a pie chart to reflect project health on the dashboard using the collected data on the report and it's giving me "The selected columns cannot be charted". Is there a way around this?
-
Using Smartsheet for Event Registration Acceptance and/or Event Registration Reporting
1) Are you using Smartsheet to collect registrations for your events? 2) Are you using Smartsheet to report on event registrations in a shared report or dashboard? 3) Can we collaborate? We are an association membership community with a limited budget. We are thinking of using Smartsheet for several different use cases: A…
-
How to build Charts from Reports
I am curious if anyone is aware of any documentation on building charts from reports. I am actively learning as I go, but I notice that sometimes a report format works for building a chart and other times I get an error that the data cannot be charted. Is there documentation or best practices on the report format you need…
-
Count Help, Don't Know Where To Start
Hi Everyone, I would like to do a project status summary. Each parent is a school site, and the children are the projects that need completion. In the drop-down menus next to the projects I change the project status to complete when done. I'd like to create a list of all the school sites included in this project that shows…
