-
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…
-
Moving value labels on stacked graph
Is there any way to change the location of the labels on a stacked graph? They appear to the right of the bar and with multiple items in the stack, it is misleading as to what the label represents. See below - the 4th item down in grey represents 60% but the 60% label is on the yellow bar. We want the graph to look like…
-
Dashboard Form Link Icon
This happened once automatically without me doing anything special, but I can't seem to reproduce it. On a project dashboard, when I created a link to a Smartsheet form, Smartsheet recognized it as a form link and gave me a nice icon. Was this feature introduced and then quickly removed, or something? Anybody know how to…
-
Chart Widget = Edit Columns included in the Data Source
Hi everyone. I am using a Project Dashboard template and I need to modify the Chart Widget to reflect the progress of the project by completion %. Unfortunately when I try to edit the column on Edit>Data & Chart type > Columns included I get this message. As a result the widget shows as 100% when in reality only 10% is…
-
How to embed Outlook calendars into Smartsheet dashboard?
I would like to have a Smartsheet dashboard that includes multiple Outlook calendars. I tried to use the Outlook share link and Smartsheet gives me an error, saying "We couldn't fins any embeddable content from this link." Is it possible to embed Outlook calendars into a Smartsheet dashboard? If so, how?
-
Column categories in chart missing
Dear All, I have the report below and would like to create a easy stacked column chart with the groups as category labels (Product and go to market). What do I need to change? Best, Karin
