-
Why do only some columns from sheet show up as dropdown options when creating a report?
When creating a new report, I select my sheet, then want to select the columns I need. However, Instead of all columns being listed in the Column drop down, I only see 4. Does anyone know why all columns would not show up or what I am doing incorrectly?
-
No Dropdown for the 'Enter Value' cell in my report filter/s listing "Current User"
I'm trying to create a report using the 'Current User' filter feature. However, when I attempt to setup the filter in the report that I just created, there's No Dropdown for the 'Enter Value' cell. I just get a text box. Also, the 'Enter Value' text box has a red outline prior to attempting to type something. Nothing…
-
Group Multi-Select Dropdown and Multi-Select Contact Columns within Reports
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…
-
Item Changing with New Information Need Reporting Help
I have test for items a,b,c,d and a report that is pulling data from those tests. Occasionally I'll have an item that will turn to a version 2 now considered a2. Column information wont change. Now there will be an a, b, c, d, and a2 rows. What should I do to pull the correct information to my report now that a (the…
-
Problem with Multi-sheet Report interpreting identical columns as unique
I am having difficulty with not understanding how to force SmartSheet row reports to understand that a particular column I have on multiple sheets is indeed the same thing, and I want it displayed on the report as a single column. It somehow does this automatically and sometimes correctly identifies this, other times not.…
-
Will the report treat two different properties of a same column as two different columns?
When I created a Report from several Sheets, all of which have the exact same column names, except a couple of columns in a couple of Sheets use a different property type, namely 'Symbol" vs "Text/Number" , the report treats them as if there are two diff columns. Is that right, or am I missing something??
-
Select one of drop down not available on filter
For our Task owner column I want to filter by current user. The select on of is not a option for me on this filter.
-
Dropdown of column names for all Smartsheets in the organization
There is a fundamental function missing in the Smartsheet of naming columns same fields as other sheets for consistency prevent automation errors due to sheets primary column conflicts reports end up having several columns with "älmost" same names, when you do filters you will need to add the filter for both names,…
-
Merged: Visible Column Description in Report
This discussion has been merged.
-
Reports Duplicating Columns with Identical Column Names
Happy Monday Community! I am building a report, and I am trying to understand why I am getting column name duplicates when they are exactly the same. Both sheets are built off of a template so they should be exact matches, and I checked both sheets and the column name spelling is exactly the same. I even copy/pasted from…