-
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…
-
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…
-
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.…
-
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…