-
Merged: Change Report Column Header Name
This discussion has been merged.
-
Maintain Column Freeze When Saving New Report
Currently, if a report has frozen columns and is Saved As New, the frozen columns do not transfer over to the new report. This creates an unnecessary additional step in maintaining the new report(s). It would be helpful if the frozen columns carried over to the new report when you Save As New.
-
Report Sorting Question
Hello, I am not able to sort a count column numerically from largest to smallest. In this project, I am grouping departments to measure how many departments submit the most requests. I am able to group the departments by name, and summarize the departments by count. However, the report will only sort the columns by the…
-
Merged: Change Column Name in Report without Changing Source Column Name
This discussion has been merged.
-
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…
-
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…
-
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?
-
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,…
-
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??
-
Merged: Visible Column Description in Report
This discussion has been merged.
-
Column descriptions
Hello, Why i do not see Column Descriptions in the Report? thanks!
-
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…
-
i am not able to sort in smartsheet reports when Multiple source file(sheet) is selected?
I am trying to sort based on the YTD summary, which is a numerical value, but Smartsheet won't allow me to sort it, it sorts automatically based on the alphabetical order which is available on primary column. Anyone faced this issue or have any solution for this?
-
Reports with multiple source sheets: Highlight Columns Missing from specific sheets
I don't know about everyone else, but when a report references a column that is deleted, it's not easy for me to figure out which column is missing. Sometimes I remove the wrong one thinking it's the culprit. So I start deleting until I find the one, refresh the report to bring them all back, then remove the one that…
-
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.…
-
Why am I not able to summarise a column in a report?
I am trying to summarise a column in a report. The column is a Text/Number formula that says 'Late' if an enquiry is late. I just want it to count how many late there are but Smartsheet isn't letting me. Often the option to summarise this column isn't there but if I remove and add it again, the option appears but it…
-
Adding columns from different sheets to the Report
I have a Report that i have been using for some time, and I add and remove columns from the source sheet with the formula and color-coded status. I would like to include the column from a different sheet, also with formula and color-coded status. All it does it pasts the collum and the title but no cell context (column…
-
View Multi-Day Tasks in a Report Grouped by Day
I have built a scheduling tool in Smartsheet for my Team to track standard, ad hoc, training, and PTO. I have setup a report that pulls scheduling data from multiple sheets with tasks grouped by start date. I use this report to see how my Team is scheduled during a given week. Unfortunately, in this report, tasks that…
-
Why do reports change column name for Modified by and Modified columns?
I have multiple sheets I'm rolling up into a report. Each sheet has a "Modified by" and "Modified" column, except I've renamed them (in every sheet) to "modified_by" and "modified_date". However, when I create the report, it only let's me select "Modified by" and "Modified" as the column names. Why? Does anyone know a…