-
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…
-
Report not pulling info from sheet #2
Hello, I am trying to pull the column Tech Level into a report that is pulling from 2 sheets. The report is pulling correctly from sheet1, but I can't get it to pull the tech level column from sheet 2.
-
Dashboard Update Automatically Daily
Hello, I'm having issues with a dashboard I have set up, not updating information from a sheet until that sheet is opened/refreshed. I currently have a sheet with rows of names and corresponding dates; basically, shift schedules by day. I then pull whatever names correspond to today's date into a sheet summary and have a…
-
Problem with Multi-sheet Report interpreting identical columns as unique
I am having difficulty with not understanding how to force SmartSheet row reports to understand that a particular column I have on multiple sheets is indeed the same thing, and I want it displayed on the report as a single column. It somehow does this automatically and sometimes correctly identifies this, other times not.…
-
Sheet Summary Report and Dashboard Widgets
Hi! Can I use a Sheet Summary Report to drive a Metric widget? I have 25 project sheets that I would like to roll-up into a sheet summary report. I would then like to create dashboard metric widgets using this data. I am currently driving the metric widgets off of the individual sheets, but this is getting cumbersome as we…
-
Is there a way to create 2 Reports from one Sheet with different formatting?
I am looking to create 2 Reports from one Sheet that contains employee time off requests. The Sheet contains 13 columns, but for simplicity, the relevant fields are as follows: Employee Name Division Start Date End Date PTO Used (# of hours) Approved? I would like to have one report for the managers to show Name, Division,…
-
Median and Mode options in Report Summary Options
We use Median for a lot of metrics as it helps to remove the outliers that can skew the data. Please add Median and Mode (if you are already updating it 😉) in the summary options for the reports.