-
Can you have an embeded task list in dashboard that copies?
I want to make an interactive dashboard. Can I embed a task list into my dashboard, of my Project template set, that will link to the new copied smartsheet? The simple answer is it links back to the original sheet link it was copied from. Is there a way to make it work? Then you only have to interact with the dashboard and…
-
Permission when sharing dashboard
Hi, I've shared dashboards to unlicensed users in my company with "admin" permission. However, some can edit the dashboard; some can't (they don't even see the pencil icon near the share button). I don't know why because they are all unlicensed users shared with admin permission. Can someone know about this and help me…
-
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…
