-
Report does not display sheet dates or dropdown menu items
Hi there, I used the "Project Management Office" template to set up different projects and then a report that pulls the information from all the projects into a central report document. I have noted that if you have drop-down options in your original sheets, or dates, these are not displaying in the report. How do I…
-
Report Filter Update-Multiple
It would be a good option to update multiple reports which use similar or same filter and/or source to get updated in one instance rather than going in and updating multiple reports multiple times, this would reduce time and effort when there are changes in the source data sheets. hope this can be done
-
How can I get the Summarize function in report to use a standard unit?
I am writing a report, and the base data gives % of a person's effort. For some reason, when I sum the totals for a category, some of the groups give a whole number, and others give a % value. In fact, it would be great to sum to a whole number, like the row for Total and the row for Sponsored, since 100% indeed equals 1.0…
-
Can't figure out why one column in report has non-matching column name?
We've created a report consolidating 31 separate sheets each with a "Station" column. However, when selecting the columns, Smartsheet creates a second "Station" column that only references a single sheet out of the 31 source sheets. This column includes the help text "Includes 1 non-matching column name(s)". All "Station"…
-
Why is the Report Builder Icon not showing? Just a refresh button.
Hi, I'm new to Smartsheet. I'm trying to edit the columns in my report, but report builder is not showing. All I see is a refresh button. I've included an image below.
-
Grouping and summarizing in reports
Is there a way to have two separate groups in reports? Not one "then" another, but two separate ones. I have columns with checkboxes, and I want to group them separately so we can see which rows have "Answered?" checked and which have "Follow-up?" checked, but we don't want it to group in this way because we will have some…
-
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…
-
Merged: Group by a multi-select column
This discussion has been merged.
-
Reports - Percent Option with count, sum...
I would like to see an additional option for a secondary value-based column for percent of count, percent of sum on Reports. And the ability to pull that into the Dashboard in a chart.
-
Separate Text/Number Column Type
As the owner of a data sheet, my data cleansing would be significantly reduced if the column property could be set as a text only or a number only. When I have a column in which I would like a number to be added, some people put "TBD" which messes up my connected dashboarding calculations. Can we please have the option to…
