-
Best Way of Being Able to Display Data Using a Current Sheet, Archive Sheet and Summary Reports
Hello, I'm assisting some colleagues with a solution that helps track music session bookings. There are a number of summary reports set up, which the metrics are then displayed on a dashboard. It's been set up for exactly a year, but they only want the current financial year's data to be displayed. They came to me asking…
-
When are more advanced customization features coming for graphs in Dashboards?
I just realized I cannot customize the x or y axis to show more custom increments or even time series (in day by day format). I am sure this is a common request and use case and am wondering when new features might be coming to the Dashboard graphs.
-
How to change count to percentage in stack bar chart?
Hi SS Community, I have attached two stacked bar charts I created for showing status of part shipments between sites. An example of the formula I used in my supporting sheet is: =COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") If it is a formula issue, what do I need to add/change about…
-
Is it possible to share a Smartsheet Dashboard to free collaborators with just a URL link?
Hello, I'm really hoping someone can answer my question! I am trying to create a dashboard that can be accessed by non-Smartsheet users with just a link. The only option I see right now is that if you do use a link, that person must already be "shared" onto the workspace. I am trying to find a workaround so I do not have…
-
How to use project status report and templates
Hi, I'm still new to ss and how to use free downloads! I'm stuck on how to use the Weekly Project Status Report Template like its shown in the image marked "report layout". I downloaded the template to which I have to complete the data (ref. image- "template layout". The issue is that I'm missing a key step to convert the…
-
Multi-dashboards, with same names, using single sheet summary
I am attempting to create 2 separate dashboards, for 2 different regions, from a single Smartsheet, using Sheet Summary. I can not seem to figure out how to name the summary fields the same or conversely alter the names once they are in the separate report and/or dashboard. Does anyone know a workaround for this? I would…
-
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.…
-
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…