-
Is it possible to embed an Excel pivot table on a published dashboard (for external viewing)?
I have an Excel pivot table I'd like to surface on a published dashboard, for external viewing. I shared the Excel file using Share -> Embed to get the link, and then I added it to the dashboard using a "Web Content" widget. However, it's not working. It displays to external users as shown below. Anyone know how to do this…
-
Is it possible to display a graph from an excel file hosted on Sharepoint on a Smartsheet Dashboard?
I understand it would be possible to upload the excel file into Smartsheet and display it that way. I'm looking to see if I can link to the excel file itself and have the excel graph displayed automatically in real-time in a Smartsheet dashboard? Thank you, Jeffrey
-
Truncate currency data labels on dashboard widgets?
Hello everyone, I have a dashboard where monthly financial and fundraising info is displayed in line charts. The time frame displayed is a calendar year, so for the first few months of the year the chart is fine. After a few months however, the data labels - some for 7- and 8- figure amounts - start overlapping one…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Colors in Column Charts
All -- I am trying to create different colored columns in my chart, but I'm not getting the option: ... unless I deselect "Switch Rows and Columns," but then I lose the column headers on my chart: The Help and Learning Center is woefully unhelpful on this question: That's all good and fine, but is there any way to choose…
-
Why can't charts widget select columns from sheets?
I'm setting up standard line graphs through using the charts widget on a dashboard. I am pulling the source data from sheets which get updated once a quarter with information I would like added to the report automatically. It seems that I can only select a data range and not select the entire columns so that the graphs…
-
Why does my dashboard widget always end at 120%? (see photo attached)
I am trying to develop a dashboard column widget which shows the progress of items by percentage. For some reason on the graph it is showing 0% - 120% instead of finishing at 100% - see image attached. How do I fix this?
-
Typing Minutes of meetings directly in dashbord
HI all We do our meeting with a dashboard a couple times a week. We have a chart that shows the development of all our current projects and products. Sometimes we need to write notes to the projects, (which we have a grid for in the project folder), but it would be great if it was possible to write notes directly into that…
-
How can a contact field by aggregated to show a count?
I have a list of projects and each project has an individual as a contact. An individual could be listed for multiple projects. I'd like to chart to reflect how many projects each individual is responsible for. The trouble I'm encountering is that the report doesn't allow me to summarize on the contact list field and the…
-
Project Tracking & Rollup Dashboard Question
Help! I'm new to Smartsheet so this may be a dumb question. On the dashboard template "Project Tracking & Rollup" why doesn't "Percent Complete" (16%) under Project information) match the "Complete" status (1%) on "Tasks by Status" widget? Confusing ... Thanks!!!!!!
