-
Ability to add rows directly from within a Report
Reports are a great way to visualize data in the way you'd like: filtered, grouped, summarized, and sorted. The problem is they lack the ability for a user to ADD a row. Example: If I give colleagues a filtered view of data that are relevant to them (say, from an underlying sheet they don't have access to), they can easily…
-
Merged: Feature Request – Enable Copy and Paste for Header Columns
This discussion has been merged.
-
Is there a way to show which reports are built off a sheet?
Hi there, I saw some discussion about this a few years ago, but as an admin, is there any way for me to create a list of reports that use a given sheet as a source? For example, for sheet A, can I pull a list of all reports that use Sheet A as a source? Thanks! Jackie
-
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…
-
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?