-
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…
-
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.
-
Any workaround for Primary column being the first column in a grouped report?
I actually feel a little silly even asking this, but I have a user request to do move a couple of columns to the left of the primary column in a report that uses Groups. Unfortunately I do not have a great response and I hope the collective awesomeness of the Smartsheet community has a better answer than "I can't make the…
-
Allow Count Unique Values Only In Report Column Summary
In addition to being able to count and sum a column in a report, I'd like Smartsheet to be able to count UNIQUE values within a group. For example, I have a report shows me all tasks from multiple projects and groups by project manager. If I try to count the Project column to see how many projects each Project Manager has…
-
Using Check Box Column to Filter in a Row Report
I'm trying to us a checkbox column with a character "-" to filter items out of a report. I use the character with a white font to hide the checkbox when it's not needed in the row. When I select the criteria in the report filter (is not one of, is not equal to, does not contain, ect..) it does not filter the character…