-
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…
-
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…
-
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…
-
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.…
-
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 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…
-
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…
-
Merged: Report Column Header Color
This discussion has been merged.
-
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.…
