-
Why did new report builder not translate logic from old report builder?
A previous report logic is not working in new report builder. I have, so far, been able to duplicate the logic of the old report filtering using the new report builder
-
Drop-down box not working in Report
We have a smartsheet that has a column whose properties are set to include a drop-down list. That list included the selections (Yes, No, N/A). When you click into a cell in this column the drop-down list works as expected. This column was pulled into a report. I can select the cell. However the drop-down list does not…
-
Published report not opening in mobile view in Chrome on Samsung phone
I have a published report that is a weekly schedule for a roster. When i click the link to the published report from my phone and it tries to open it in Chrome mobile view i get the attached error. However, it will show when i change to view as Desktop site. Is there an issue with the mobile browser view for smartsheet ATM?
-
Report Grouping
Mostly love the new report interface - including grouping, but I don't love what's it's doing to my client name when I group. See example below. Is anyone else having this problem? It doesn't handle apostrophes or ampersands properly. Other than renaming my client, is there a solution to this issue?
-
Grouping in Reports
Is it possible to group by a column in reports like Excel does? I need to create a report that groups projects by OKR/Goal and then by Project. So management wants to see how many projects are there per OKR.
-
Pivot App - How can filter a field
Hi there, I'm new using the Pivot App and I was wondering if there is a way to filter any of the fields in the pivot table. I have an excel pivot table that I'm trying to replicate in smartsheet from a master data that already is imported into my smartsheet. There is a column in the data master named "Current Status" with…
-
Printing a dashboard and one of the widgets is unaligned
In the online version, everything is perfect, when I print it to PDF, the milestone chevron lanes don't line up with the "assigned to"/"health"/"status" columns. How can I fix this?
-
Auto-Generated Date Report
It seems that you cannot run a report based on a filter condition such as "Not in the past X Days", if you are having the condition look at an auto-generated date. That seems odd, because within the grid, you can run a filter based on that same criteria - "Not in the past X Days" - and it works. Anyone know if you have to…
-
SUMIFS Formula for Rows Assigned to Multiple Contacts
Using the Sheet Summary function this formula worked: =SUMIFS({Budget Projected}, {Budget Account}, Variable@row, {Budget Assigned}, Employee#) when the lined was assigned to only one contact, but now that I have lines with multiple contacts assigned to them it will not recognize even the one employee's name anymore. I…
-
The new Report - missing " remove formatting" - search not working well
Hello I see there have been some pretty major changes to the Report interface, recently. 1) I used to be able to "remove formatting" so the source sheet formatting didn't carry over to the report. Where is that option, now? 2) It seems a report now has a max of 500 lines. I wanted to search my report for an item but it…