-
Widget Report Format
Hello. I am building a dashboard with high level information including total requests submitted into the sheet. I was able to create a report and add it to the dashboard but I do not like the formatting. Is there anything I can do to customize and center the total number?
-
Grouped Report
Hello, I need a report to group an underlying data report from Resource Management to show only one line item per project name. I also need to see the start and end date (no dependencies), Project Manager, Client, Incurred (hours) and Budget (hours). I can get it to group by project and sum the incurred (hours) and the…
-
Hello how can I produce percentage through the reports Data that are not percentage
for example - I have 5 employees who fill in online forms and I have to produce a report from all forms that will be divided into a percentage according to each employee Michal - filled 5 forms yoni - filled 5 forms total of 10 forms which means that each one of them had 50% work. i want to show it on the dashboard as a…
-
Create a report from multiple sheet but with row as Columns
hi Friends, I am trying to make my Smartsheet work better for my user. the problem that I am facing id the following My Workspace is build in the following way. Each of our project have a specific folder name let say Project1 , Project 2, Project 3 In each of that folder we have many many files, one of them there is a…
-
Allow sheet Summary Reports as a source for Dynamic Views
It would be helpful to be able to share summary field information from multiple projects using Dynamic View and a Summary Report. Summary Reports are an excellent way to share summary field data for multiple projects. Sharing this data using Dynamic View allows the owner/admin to show key fields in a grid, then make…
-
Request: Report summaries should count checked = 1 and unchecked = 0 for Checkbox columns
Love the reporting column summaries feature for most column types. However, the Count summary option isn't very useful for Checkbox fields. I want to see how many "violations" there are which we denote with flags being checked or unchecked. I'd expect the following scenario to return "3" and not "5". Or am I missing a way…
-
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
-
Hide comments in a published report?
Hi there, Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. There are comments in our main sheet that the report is built on which we do not want to be visible in the…
-
Add "Latest Comment Column" for SmartsheetGov users
Right now, I'm able to see comments added in sheet form and in a form generated from Request for Update workflow. What I would like to have added to the SmartsheetGov side is the Latest Comment Column so that comments made on sheets can be displayed on reports and/or dashboards. Having this feature for SmartsheetGov users…
-
Current User Filter showing blank report
I am trying to use the current user filter for a report I setup. The filter is based on the Project Manager Contact List Column and the report should show records when the Project Manager column is = Current User. It works for me but no one else. The people have editor rights to the underlying sheet and to the report…