-
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.
-
Using Row Comments in a Formula
Hello! I am currently working on a dashboard, and need to populate rows that have comments. Is there a way to do so or is there a formula I can use to indicate if a row has comments? I tried doing an IF statement, but I am not sure what the row comments would be referred to. Any information provided is greatly appreciated!
