-
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…
-
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)…
-
Why am I only allowed 1 sheet to source in reporting on Free?
I used to be able to source multiple sheets in a report, but now I am only able to source one sheet. When did this happen?
-
Request Update in Conversation
I have just inherited a sheet that is being used weekly status report. My PMs have been logging in and updating a single box with an update on the weeks progress. So far, so good. I want to change to use the conversations tab so we retain the history, and use the "latest comment" for the field on the sheet. I wanted to use…