-
Mobile app shows published content URL instead of the content.
Greetings. I've created a dashboard that displays published Smartsheet sheets (Read Only - HTML option) via a web content widget. Works great on the desktop browser version. When I view the dashboard on the iOS mobile app I see the link to the published content and not the actual published content. What do I need to do to…
-
Finding a Smartsheet Contractor
I'm looking for information on how to find Smartsheet contractors to set up a complex project with dashboards and reporting as well as train our team, document the process, etc. Is there an existing discussion on this topic? I'm looking for any available guidance that anyone may have to offer. Thanks!
-
Multiple Workspaces to 1 Dashboard
Good day, everyone: I work for a company that has multiple HRIS implementations going on at one time. We are looking to take multiple project managers workspaces and connect them to 1 dashboard that shows status's of all the projects in the company without multiple entry points. Can this be done organically with SmartSheet…
-
Dashboard Calculations -- will they ever be a thing?
Hi, I need to display a bar chart in a dashboard that has one bar for assignee in a project plan. The value of each bar will be the count of late items for each assignee. the only way I can figure to do this is to have an interstitial 'summary' sheet with one row for each assignee, where their name is in column 1, and a…
-
Top 5 Producers Chart Creation
Hello! We want to post a top 5 (or 10) list on a dashboard to dynamically display producers with the top 5/10 highest total sales in both count and $ amount. We have a master sheet to capture this information but cannot find the right formula or approach (maybe a helper column?) to produce this. Any help is greatly…
-
Summarize data by totals
Summarize data on reports by totals, so that on the dashboard, the charts can show data from highest to lowest (total numbers), and not just in alphabetical order.
-
Configuring a Metrics Widget - can it be done?
Full disclosure - I have been using the PMO template and modifying it for our needs. It was a great starter, but needed some additional tweaks to suit our purposes. I added a sheet that dynamically collects all the unique names to make it easier to dynamically display them on my dashboard: (a big thank you to @Cleversheet…
-
Dashboard breaks after removing an Admin (original owner/builder of Dashboard but not current)
We have a Dashboard (several Dashboards that this same behavior happens on) that was built by one person. The Ownership for the Dashboard and ALL associated items (Metrics Sheets, Reports, Source Sheets, etc.) were transferred to another person. The person who built the Dashboard originally (who is no longer the Owner of…
-
Average if multiple criteria
I am looking to see if there is a way to have multiple average ifs to show a visual for the current working project So IF status = working, and assigned to Group 4, I am looking to show average # of days: 1.) Submitted to triage 2.) Triage to start 3.) Start to Root cause 4.) Root cause to council approval 5.) Council…
-
Copy text from text rich widget
Copy text from text rich widget on dashboard. Currently cannot select text from a widget