-
Report/Dashboard Question
Hi all, I am building reports and a dashboard for the support tickets my team receives. I want to create a report and chart to show the number of tickets our clients have submitted so far this year. Since we have well over a 100 clients, there are some clients that have only submitted 1 ticket this year. I'm trying to…
-
Can Document Builder leave a PDF as Fillable?
Hello all... I am struggling to meet a simple ask from my boss. He is looking for a Capacity Modeler, where managers can list out tasks they need completed, assign a maximum efficiency for each task (IE if the employee was doing literally nothing else for x time), and then assign what percentage of a given employee's time…
-
Widgets in Dashboard: Aspect Ratio
This discussion was created from comments split from: Dashboard Improvement. Aspect ratio: setting for pixels in Dashboards
-
Dashboard enhancements to make them become a better tool
The dashboards are great with Smartsheet's but there a a couple of limiting factors that create a duplicate of data which creates more maintenance. I know it is supposed to be limited to one idea per post and the main idea is dashboards but there are sub topics to improve the dashboard.... (1) First off is to enhance the…
-
Seeking Assistance - Average Days Open, by Status, Month/Year
Hi All - I'm trying to calculate the average # of days for data set, where the Status is "X", and the M/Y = "Y". I'm good with "AverageIf" = label@row, but not sure how I can incorporate the date piece. Thanks in advance! Sharing some snapshots of the data, all columns (Total Days Open, Completion Status, Leave Blank...)…
-
Resource Management
Is there a way to create a master agile resource tracker and link it to every other project without having resource management?
-
Analyse three columns content and produce a representation of request priority
Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service booking summary Smartsheet we have a department ID of the requester in one column, a "date created" column, and a column that shows the user/form…
-
Dashboards: Show 'Assigned to' count for each user
Hi, I'm new to dashboards. I want to show the workload assigned to each person. My 'assigned to' column has several names for every row. Am I correct in thinking I need to create a copy of the basic report, filtered to each user so that these can be linked to individual widgets on a dashboard? Any advice would be…
-
Current User Report on Dashboard - NOT SHARED
Today if you are using a Current User Report on a Dashboard you have to be shared to the source sheet. If I don't want people to see the data, there is no easy solution. Please allow the current user report to work by filtering in for view on the dashboard, not source data. Dynamic View doesn't have all the features of a…
-
Merged: Create "Current User" charts on dashboard without sharing underlying data
This discussion has been merged.
