-
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…
-
Filter by Cell Color in Reports
When creating a report from multiple smartsheets, I want the functionality to be able to filter rows by color. This way, if I need the sum of certain rows/parent rows, while excluding others, I can easily do so without duplicating numbers.
-
Need help with a master report to create conditions within a calendar.
I am trying to create a master report where it shows vacation days for the team as well as due dates for the projects they are working on. With that being said, I would like for the start/end date to show on the calendar for vacation, but ONLY the end date to show for the projects since they are usually pretty long…