-
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…
-
Formatting report data coming from Sheet Summaries
Hi, I have created a Sheet Summary Report which pulls data from the Summary tab of multiple source sheets. Nothing easier, right?? But, I can't see any way to center-justify the data in the report (because normally it grabs the justification from the source sheet column). Is there a command somewhere I'm just not seeing?…
-
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…
-
Group Multi-Select Dropdown and Multi-Select Contact Columns within Reports
It would be great if we had the option to group line items in a report by options selected in a dropdown column. Ex. If you are viewing projects within a global campaign and have "country" as a column with the fixed values for all the available countries. It would be nice to be able to run a report where you could group…
-
Report Issue
Hello, we have created some reports with a full workspace as data source to share filtered data specific for several departments. We have observe that Sheet Selected number varies between some users (i.e even having them both Admin level for the workspace, 1 users see 322 sheets as source of data and the other 352)…