-
Project Task Rollup Report Template Question
I was using the Smartsheet Template for Project Tracking and Rollup, and one of the reports in that set is called the Task Rollup Report. I was trying to replicate it for another Project Plan I was using (not as a part of this template set) and can't figure out how it's getting the fields that are in the drop down for…
-
Stacked column/ bar with two grouping option
Hi Team, I'M currently developed stacked bar using a table with columns and rows in report, but I wanted to check if it can be achieved by two-grouping option in a report?
-
Full Screen View Default for Published Report Widgets
I would like to have an option for reports that when it is published, I can default it to full screen view. Currently, you would have to manually click the expand button to remove the top blue bar. "Normal" View: The below icon will expand the report to full screen view. I want this to always display the widget in full…
-
Can I make a visual timeline on the dashboard showing completion for next quarter/ 6 months/ etc.
Is it possible to add a chart in the dashboard like this as a way to add a timeline representing specific projects of high importance to show completion dates for next quarter / 6 month etc. Not sure if that is possible but hoping to get some ideas!
-
Visualize categorized count data
Hi Y'All, I have a small task that I do not know how to solve. We collect project data and one specific info we are counting and, I would love to visualize is: How many contracts were signed in year xx and quarter y? As background, my data structure consists of 1 project per row. A column is a manual input called "signed…
-
Free Text Field for Location in Smartsheet
Is there a way to create a report and widget for a dashboard that will illustrate the number of requests per location based on form that is free test?
-
Creating a graph from 3 variables
Hello, I would like to create a graph in SS from using three variables: CSP name, Observations (Critical, Major and Minor) and Categories (findings). Please find below example: I did create report from the sheet and tried to create Chart in Dashboard, but it says "Selected data can not be charted, please select a new…
-
Multiple Date Ranges within the Same Row
From what I read this is still not an option with Smartsheet. I would also like to have multiple date ranges within the same row. I would like to be able to look at a project (start to finish) but also like to see Section A, Section B, and Section C date ranges within that project on the same gantt chart row. I currently…
-
Is there a way around the row limitation on report widgets within a dashboard?
Hello, I have a dashboard which shows a summary of key information from a sheet that outlines purchasing history of our company. It pulls from a report that summarizes information from the main sheet as a widget on the dashboard, and allows viewers to scroll down through the history of purchases line-by-line should they…
