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…
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…
This discussion has been merged.
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.
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…
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…
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…
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…
