-
New Program Reports for Blueprints
For the New Program Reports, are they included in the 50 dynamic report limit? I already have 46 dynamic Reports, however, would like to create several more….
-
NEW! Program reports
Hi Community! As a first step towards a new best-in-class portfolio reporting experience in Smartsheet, we've made it easier to quickly create reports that pull data from one or more Control Center programs. Simply select the blueprint templates you want to include and filter by project status to get the exact insights you…
-
Form fields to include Comments
It would be really great if, in the manage forms section, form builders are able to insert a comments field that would populate as a comment on the row once the form is submitted. I have searched many product ideas and did not see this, but I did find older conversations in the community stating that it would be desirable.…
-
Report with control center projects + other sheets
Hello, I have decided to test the control center provisioning projects in unique workspaces (1 project = 1 workspace), while they were previously all provisioning in one workspace. A side effect has been that the reports of my consultant, which were previously looking for sources in that one single workspace + other…
-
Dynamic Reporting Linking Filters
I would like to make reports dynamic so that you can link filter options to another sheet. For Control center this would be great because you can have the intake sheet (Where the data lives) drive into the report and populate the results. We would like to see it linked so if you change the data on the intake sheet, the…
-
Selected data cannot be charted - shouldn't be happening
I have a report that I want to use as a data source for a chart on a dashboard. The report has summaries and the required grouping so that the top-level row of data can be used for the chart. Even though there clearly is numerical data for a chart to be created (see below), I am getting the error - "Selected data cannot be…
-
How to get the count of unique values from a list of repeated unique values
I have a list of people lets say Jon Sam Rick each on of them is assigned to a colour lets say any combination of colours for something that looks something like this ( see screenshot). How can I count the number individual colours for each person. For example Jon has a combination of 5 red and 5 green so his count should…
-
Why do only some columns from sheet show up as dropdown options when creating a report?
When creating a new report, I select my sheet, then want to select the columns I need. However, Instead of all columns being listed in the Column drop down, I only see 4. Does anyone know why all columns would not show up or what I am doing incorrectly?
-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
-
Request to Restrict Sheet View by Current User in Report
Hi, I'm looking for a way to restrict the view of a sheet so that each user only sees the rows relevant to them. I know this can be done using Dynamic View, but I want users to be able to update multiple rows directly in the sheet, without having to open each row individually in a form. Here's the situation: I have a sheet…