-
Modified "Report" for client
I have a contract with 262 units that are being reported into 10 database sheets. The finished product I am looking to have is a sheet with the 262 units displayed vertically with the Projects horizontally, with the quantity reported on each project in the row of the corresponding unit. I was successfully creating cross…
-
Saving a copy/snapshot of a report
Can I save a copy (or snapshot) of a report with the data fixed as it is on the last day of every month? I've tried Send as Attachment… but I want to keep the copy/snapshot in Smartsheet with its grouping and summaries rather than preserving only the data in XLSX or PDF format.
-
Block Publishing Blank Reports
I have reports that get emailed to clients weekly, if they don't have any active projects they are receiving blank reports. Ideally, we would be able to stop blank reports from publishing without having to manually stop/start the recurring email each time they have no active projects and instead Smartsheet could pick up…
-
How to automatically have a report update when a new sheet is created in a workspace
Hello! I am trying to create an ongoing report/ chart with a workspace. So that anytime a new sheet is added to the workspace, it automatically updates the report, therefore updating the chart on the dashboard. I thought I had it figured out, but then one of our employees added a sheet to her workspace (outside of any…
-
Sort Report by the Summary result
I am having a report grouped by region and summarized by numbers of process per region. it's only sorted alphabetical by region not possible to be sorted by summary numbers. Easy feature appreciate if it could be existed soon. Thanks team, Shorouk Helmy
-
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…
-
Change Formatting in Reports
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…
-
Weekly rotating roles formulas
Hello, I am trying to create a report or calendar sheet with these weekly rotating roles: Weekly 1st shift Call Center (Mon-Sun) Weekly 2nd shift Call Center (Mon-Sun) Weekend On-Call 1 (Sat-Sun) Weekend On-Call 2 (Sat-Sun) I have a sheet with the list of [Name]s and a [Resource #] column to use for creating the rotation…
-
Merged: Visible Column Description in Report
This discussion has been merged.
-
Extract data from a Program level report
I have a report with the Report Scope set to "Programs". What is he best way to extract the reported data into a grid and keep the grid current. The report refers to 20+ underlying sheets in the program. Would it be possible to do this for a report that has multiple sheets in the scope - that is it is not a Programs report?
