-
Multi-Sheet Cap for Reports/Pivots/Dashboards
Good morning, I need to report on data spread over 50+ sheets that are updated independently. The plan had been to place all these sheets in a single workspace and run a Dashboard or a Pivot referencing them all, but I cannot find whether there is a limit on the number of sheets a single Dashboard or Pivot can reference.…
-
Enhancement Request: Dashboard open links in same tab
I would like to have the option to tell links to open in the same tab for my dashboards. I have some internal company wide sheets that I have shared by publishing in order to bypass setting up permissions to all of the pages. Where I have files they are linked instead of published to prevent access to anything private.…
-
I am trying to create small chart for dashboard
I have a master sheet that has 100 projects all different end dates. Trying to find a formula or method create small chart like a sample Jan 2022 - 4 Feb 2022 - 3 Mar 2022 - 4 Etc...
-
Embed code not iframe for dashboards
I need an embed code for my dashboards instead of an iframe. Does anyone know if Smartsheet can assist with this please?
-
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