-
Gantt view in Report
Hello, I have a sheet with the respective columns to be able to visualize the Gantt view. Everything works perfectly in the sheet. Sheet: The difficulty I have is that I do not want people to have access to the source of the data. My idea was to create a report to visualize the Gantt view. This worked, half way. In the…
-
Dashboard/Report to show status change in last 30 days
Hi, I'm looking to be able to show on a dashboard a chart and detail of projects that have had a status change (RYG) in a given period of time (last 30 days). It doesn't appear that reports allows to filter on that type of data. any suggestions? Thanks! UPDATE- solved via Automated work flow using an added date column, and…
-
Why Can't I Check a Checkbox in a report?
I haven't had issues with this in the past, it suddenly is no longer working. So weird. I have a report that has 4 columns that can be checked / unchecked. Today, 2 of the columns are allowing me to check/ uncheck while in the report, (which will update the sheet that it pulls from), and the other two columns are unable to…
-
Introducing a new report builder plus grouping and summary for reports
Hi Smartsheet Community, Starting today, you’ll see some changes in reports, with the release of a new report builder plus the addition of two top customer-requested features that help you create more powerful and informative reports: grouping and summary. The new report builder replaces the previous “where, what, when,…
-
Visual grouping of data - input requested
Hi, looking for suggestions/tools on a way to show data visually grouped ideally without using parent/child relationships. e.g. if 5 initiatives were all tied to one larger objective, I'd like to only reflect the objective once (vs. in each row), with the 5 initiatives shown to the right. I know the calendar app offers…
-
Help with project metric and resource setup
we are not using Resource Management because it is way too manual of a workflow to manage. Instead I am trying to replicate some level of a resource map by doing the following: there is 4 stage gates that are the primary workload impact for various teams with a specific Start/End for each stage. Team 1 = Stage 1, Stage 2…
-
SCC: Dynamic Report Scope - Shows grouping headers but no rows of data?
One of my Dynamic Report Scopes built in SCC is not showing any data. It displays the grouping headers, and if i change filters the grouping headers change as if the data has changed. But the actual rows of data are not being displayed. There is also a warning at top saying: Not finding the rows you're looking for? Try…
-
Why isn't the workflow triggering and moving the data to another sheet?
Hi, I have the following workflow set up where the data needs to move to the delivered sheet once the date is in the past. For some reason, the workflow is not working. Both sheets have the exact same column headings. Can someone review and let me know what's missing?
-
Disabling sheets, reports and/or dashboards without deleting them
As a company, we are trying to determine what grids, reports, dashboards, etc. that people are using. Is there a way to disable items without deleting them? That way if it is decided that we still need something, we don't have to recreate it.
-
Complex nested IF, AND with traffic light symbols
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity completion date * Start: The activity start date * Date: A column containing fixed dates to…