-
Reporting/dashboard on form entries
Our Referrals departments has recently started utilizing a smartsheet form to track key information on each referral that comes into our hospice. Each team member completes & submits the form when they get a referral. I have the sheet set to automatically date/time stamp each row as it comes in. The department heads are…
-
Can I display row numbers in Dynamic View on a Dashboard?
We have a client dashboard with a dynamic view showing progress of our projects. Is there a way to have the row number, that typically displays on the report or sheet, show up on the left of the line? Thanks!!
-
Project Brief or Project Charter in Dashboard Format?
Hi there, Has anyone created a dashboard template for a Project Brief or Project Charter? I'm looking for an easy way to compile project information and share during our steering committee meetings. Many thanks, Jasmine
-
Rolling up RYG status by workstream
Hello, I'm looking to write a formula that averages my health status, but by the workstream column. For example, in the screenshot below, I'm looking at the "Equipment and Technology" workstream. I am using a separate metrics sheet to write the formula, as there will be one roll up status for each of my workstreams…
-
Add count/sum ranking into reports to allow for better graphs
Ranking data by A to Z is helpful in minor instances but to enable ranking (lowest to highest or highest to lowest) is a massive benefit when showing data on a graph. Please can you include the feature to rank data in a report? Using cheat columns in a sheet to mimic this is a real pain and clutters up the sheet.
-
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…
