-
Report not populating with formula column data?
Hello, I have a group of sheets that populate a report with date data. One of the date columns is a formula column that is constant through all of the sheets, used to track various processes to calculate a target end date. For some reason, the data appears on the sheet but does not populate on the report. It appears on the…
-
Dashboard Issues & Privacy
I have a master data sheet with data on it for 5 different clients. I've then created a series of reports that filter information for each client so they can view their own data without seeing everyone else's data. But I can't give them access to a report without giving them access to the source sheet. So I created a…
-
Report Builder - toggle column list order
It would be helpful to have a toggle (or some other way to make a choice) in the columns section of the report builder: Alpha or Sheet Order. Most reports mirror the layout of the underlying sheets to some extent, so it would be helpful to have the column list sorted in the same order as the columns appear on the sheet…
-
Missing Reports on a Dashboard. Then suddenly appears after refreshing. Then missing again.
Hi everyone, Have you experienced being haunted by a Report widget within the dashboard? Our Clients were complaining that some tables within the dashboard suddenly went missing, but after refreshing, it will appear and then gone again. This is my first time encountering this, and I've already raised a ticket to Tech…
-
Allow report widget to show calendar view
At the moment, dashboards, it is not possible to have a report showing with a calendar view. This would be a great help for user needing to see data in a calendar format.
-
How would you measure progress by quarter
Hi there, I am hoping to crowdsource some creative answers to a question that has been asked of me by my leadership team. I currently have a Project Management Office/Organization set up in Smartsheet where projects come in with a request form and are managed on an intake sheet, get their own project planning grid &…
-
Grouping in reports does not show headers of the drop-down list
Hi I am a new user trying to test and see how much I can pull off from this amazing sheet. Well, I am trying to create a report with all the tasks for any given stakeholder. I am grouping the report based on the primary field that has values within a particular header as in the ss below: And, if you look at the report, it…
-
Merged: Update Requests Sent from Reports (versus individual sheets)
This discussion has been merged.
-
Auto-Update Report Column Names
This is a request to automate updating the report columns when the underlying sheet's column name is changed. After the new Smartsheet release that connects the old column names with the new ones, there are more clicks required to update the report's column names. The extra step is having to disconnect the old name from…
-
How to make child rows indent in a report that rolls up multiple plans?
Hi, I need to roll up detailed plans across multiple sheets, and have the parent child relationships be really clear by having child rows indented, just as they are in the original plan. Is there a way to make sure that child rows indent under their respective parents in a report? Thanks! Brent