-
Printing Group/Summary Reports
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…
-
Why is my report removing specific sheets?
Hello Smartsheet Community! I hope you can help me with the below. I have a portfolio reports folder that includes a report called MY Tasks. New projects created via the control centre are automatically added to this report so that you can view all your tasks for each project in one place. I then added two additional…
-
Reporting Sum Counts and Sum Totals in weekly/monthly formats
I am looking whether to create a Sheet Summary Field or Report based on Sheet for the following. I am also struggling with the correct formula, as well. Would like to report total # of claims and total sum of account balances for Closed Claims weekly and monthly. Weekly: would like the process to automatically update on…
-
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?