-
Display chart that shows no. of tasks assigned to each person based on priority
I created a report that is grouped by 'Assigned To' and then 'Priority'. I also have summarize on for both columns. I want to chart this data in stacked columns on my dashboard to show the no. of tasks that are assigned to each person based on priority. Ex. Bob is assigned 3 High priority tasks, 2 medium tasks, and 4 Low…
-
I need to Sum a column from a reference sheet and display the number in my primary sheet
I am attempting to build a column formula that generates the sum of hours for a given phase (task). This is an interaction of our Main project grid and the Timesheet grid (it is one of the advanced reports Resource management offers) from Resource Management. Our main project should display the number of hours incurred for…
-
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?