-
Custom Data and Roadmap for Smartsheets
I've created some amazing visualizations using smartsheets data around my companies initiatives, recommendations on fixing over allocations, roadmap view that takes you directly to relevant smartsheets page when clicked. The tool has increased the efficiency of my organizaton significanlty - maybe 10x - by having all this…
-
Merged: Centralized Visibility and Audit Dashboard for Smartsheet API Usage and Active Tokens
This discussion has been merged.
-
Keep legend, remove data value
Hi! I want to keep my legend the same and keep the color on my chart dashboard widget even when the data is 0. I have seen the workaround as adding + 0.0001 then rounding the decimal, but I think the 0 is more confusing. Any idea how I can keep the legend and not have a 0 in my dataset?
-
Calendar App Embedded in Dashboard — Requires Refresh on First Load Daily
We've created portfolio-level calendars using the Calendar App and embedded them into our dashboards via web content widgets. However, every time someone accesses a dashboard for the first time each day, the embedded calendar doesn't load the correct view — instead, it displays the Calendar App home screen (the "select a…
-
Dashboards Storytelling and Executive Insights
I work in an Enterprise PMO where Smartsheet is our project and portfolio management (PPM) tool. It was custom built for our organisation, and the Enterprise PMO maintains it (controls the templates, building reports, fixing issues, and supporting users), while project teams update their own project data. Over the years,…
-
Scaling a global marketing operations platform with Smartsheet WorkApps
Intro 🖐️ Hi Smartsheet Community, I wanted to share one of the most commercially interesting WorkApps solutions I’ve built at McCann UK for a global luxury automotive client. I’ve anonymised some details for confidentiality, but the principles, architecture, and lessons learned should be useful for anyone exploring…
-
What Smartsheet templates are you using for clinical trial tracking?
Hey guys. Currently, I’m in clinical operations. I got a bunch of Phase II & III clinical trials in Smartsheet. We moved from Excel a few months back and still don't know the best way to set things up! The main difficulties I encounter are as follows: Tracking site activation in multiple states it's too dark Enrolling…
-
Date/Text option within Pivot App Values dropdown
It would be very useful to include text/date within the Pivot App Values dropdown options. Currently the Pivot App Values drop down is limited to SUM/COUNT/AVERAGE.
-
PowerBI Connector and Reports - Visuals Stop Working after Gateway-side Refresh of Data
Context: I worked on a dashboard that's pulling dozens of sheets and merging them together into a dataset. It's time-consuming to add each Sheet to PowerBI and requires many manual steps. I've explored using a Report as it can automatically pickup new sheets automatically, adds the sheet name, etc. When I import into…
-
How do you have dashboard graphs read zero for months with no data
Hello, I'm trying to create a bar graph for a dashboard where the number of events happening (y-axis: count) is graphed over time (x-axis: time in months). For months where there were zero events, the month is just being removed from the x-axis. How do we force the x-axis to show all months, regardless of whether there is…