-
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…
-
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??
-
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…
-
Summarize Not An Option on Report
I'm working on a complex report, but the summarize option has gone away for a column that was previously working. Anyone have any idea on how to get this to return? This was previously showing, but I tweaked the formula which made this option go away. I've tried to remove the column and add again, but that hasn't worked.…
-
Nested child cards/time management
Hi everyone! I need help with a couple of things please. For our monthly KPI reports, we have to track how much time we spend on each task. How do I add subtasks to be the main task (i.e. total hours spent on that task overall) I would need to see total hours spent on the task overall and total hours spent on each sub-task…
-
Dashboard Sheet name Hyperlink proposal
I have a dashboard with a summary report that shows all my records within my Smartsheet, within the report i have the sheet name column which acts as a hyperlink and takes the user to the associated sheet where the record is located. The problem is the link takes the user to the page but leave the user having to go and…