I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
I have entered this data and am using it as a way to track allocations across different projects. The different projects are indicated by the different WRT #s in column 1. I need to then summarize the last 2 columns by WRT #, which I've done here in a report. I am wanting to add some type of flag or conditional formatting…
I made a report and grouped values in the report. When sending it via email as an excel spreadsheet, I get raw excel file, with no grouping/filters applied. Any ideas?
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
Any updates on when Smartsheets will print reports with the groupings & totals you can see on the screen? Thanks!
I have added 3 groups to selection of data and had each one summed for total but when I export to .pdf it only shows them in the standard grid. I need to be able to print it out/send the report with grouping and summary tool. If this is not possible (crazy to have but not be able to print) are there alternative ways to…
Hello, When I am attempting to build out a Dashboard I am getting the following error when selecting the report… "selected data cannot be charted please select a new range." It won't let me select other data or specific parts either from the report. I have also tried grouping it and no luck. Any recommendations would be…
This discussion has been merged.
The Gantt view in a report would be much easier to view, and use if the days off were grey. It's like this on the source sheet. All the info I can find is for modifying the gantt in a sheet, not a report. Is this possible?
I've attempted to create formulas and helper columns to accomplish my task, but I must not be understanding how to get to my desired conclusion. I would like to take a subset of my overall project plan and report that based on a set of criteria. The challenge comes in that I want a scalable solution and I would like to…
