-
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…
-
Merged: Renamed column in report
This discussion has been merged.
-
Row Report Custom Filter: Allow Basic Formulas to used to Filter Data
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…
-
Renamed a Column, Now Column Header Showing Twice in Reports
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…
-
Is it possible to hide rows based on value of a column in Dynamic View?
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…
-
Merged: Include column description in Report
This discussion has been merged.
-
Merged: Add Equation Columns to Reports
This discussion has been merged.
-
Group Report By Month or Year
It would be fantastic if there was a built in way to group reports by month or year based on a date column. Something in the group settings when you choose group. If you select a date column you would have these options Oldest to Newest by Year Oldest to Newest by Month Oldest to Newest by Day Newest to Oldest by Year…
-
How do I convert dates into a time period (month) for reporting?
I am creating a savings dashboard and my primary sheet records the date the PO is issued. In my dashboard I want to display my savings by month or fiscal period. Is there a formula that will convert my rows with PO issued dates between date ranges into a fiscal period/month. Example: I want to convert row cells with any PO…