-
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…
-
Sort a chart after Grouped by Average
I've created a report based off of a project plan. That report groups by category and then averages the % complete. From that report, I created a bar chart on a dashboard to show the % complete from the report by category. However, the chart is sorted alphabetically even though I set the sort to % complete ascending. Any…
-
Report Sorting By Primary Instead of Sheet
Hello! I am combining sheets into one report. I need to sort everything by sheet name. However, somehow Smartsheet is sorting by primary instead. I've tried to remove sorting and change it to sort by primary/date/whatever and switch it back, but I just can't get it to sort by sheet for some reason. Any ideas?
-
Different font size for one row in the Sheet Name column of a Report
I've got one row in a report where the Sheet Name shows up in a larger font than all the other rows, and I can't figure out why. Other rows pulling from the same Sheet use the same smaller font size. I tried going in and making sure all the columns in the source sheet are using the same font size, but that didn't change…