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…
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…
This discussion has been merged.
Current Build: When Creating a row report, you can filter by Column data. Example: "Month = 3" or "Percent > 75%" Concept: I want to be able to apply basic Formulas to custom filter data. Example: Month =Today(-31) or Percent > AVG([Average1]@row, [Average2]@row) This would reduce the amount of times you would need to…
I have 24 spreadsheets all using the same sheet template with the same columns, but different row/cell values. I changed the name of a column from "BLD FT-CUR" to "BLD FT-JP" on each of the spreadsheets last week. All of the columns have the same naming as the above with no column description and the column type of…
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…
Hello, Using Dynamic View to allow users to see a report where we do not want them to have actual access to the sheet driving the report, so we have a report created that the dynamic view is on. Currently the report is pulling all data based on a couple filters. Ideally the group that owns the sheet and report can see…
Hi all I am trying to group the report by certain columns only when I go in to add columns they do not appear. The specific ones not showing up are the "Assigned To", Objective" and Quarter Columns. Anyone have ideas on how this can be resolved. Thank you.