-
Metric Widget is referencing sheet that has met the 500,000 cell limit - What do I do?
I have a dashboard widget that is referencing a sheet that recently met the 500,000 cell/row limit. I thought breaking out my sheets by year would be enough space, but I was wrong. Is there a way to keep the look and feel of my dashboard widget, but have it reference 2 sheets (or something like that)? Thanks, John Stanik
-
Why does my dashboard pie chart not show the same information as the data it is charting?
The data below is what I am trying to chart as a pie chart. The pie chart is only showing 708.14 and 1992.83 but if I make the same chart a bar graph it shows the data correctly. Why is this?
-
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…
