-
How to count number of projects in 2023 by current status
Hi, I created a Metrics sheet that feeds a dashboard last year that counted the status of a variety of items and it worked great when there was just one year. This year, I now need to only count the items that are for 2023. In the main sheet, I have a column that has the year in a string format (it's a formula…
-
Expand library of approved domains for the embedded widget on dashboards
Our department utilizes Maptive for map creation on various information/data. It would be helpful to expand the library of approved domains to include maptive.com to the dashboard embedded widget. Thank you, Pamela
-
What's the best way to get a total count and also categorize the results?
I'm creating a dashboard for our team on submitted tickets but the requestor wants this data to show total ticket amount per team member and also have it broke down into completion dates. Ex: Jane Doe: Total Tickets 100 Completed 1 day or less - 50 Completed in 2 days - 25 Completed in 3 or more - 50 I'm pulling this data…
-
Stacked bar chart that only goes to 100%
Hi, I'm trying to create a stacked bar chart that combines the Actual number, the Deal Model Number, and the projected number into one line. I'd like the bar chart to only go to 100% and as the Actual number goes higher, it shows it creeping up the bar towards the deal model / projected number. I'm not even sure what kind…
-
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…
