-
Change default time frame in published calendar view of report in Dashboard
I have a dashboard that integrates a calendar view of a report. It always opens to a time window of one month, but I'd like to make this default to two weeks. Can this be done? Thanks.
-
Create a dynamic unique count metric sheet for a leaderboard
Hi All, I'm looking for a way to create a leaderboard from a sheet that tracks incoming submissions. We want to track the unique visitors and how many submissions each has created over a period of time, and I'm having zero luck. Any help would be appreciated!
-
what's the best way to display the legacy project resource view or the icon on a dashboard?
-
OneNote Link as Web Content in Dashboard
Hi all - I'm looking to make access to a OneNote notebook available through a Smartsheet dashboard. I have been trying to do so by using the Web Content widget, but when I go to paste the public link, an error shows up in the widget. After looking through some Community answers, I'm noticing that there isn't a OneNote…
-
A Template that is more friendly way to set this up
I hope that my screenshot is helpful, but i am still using new tools in Smartsheets, but i was wondering if anyone had any idea of a way I can set up my 1x1 meetings, per supervisor in Smartsheets. So i have 3 departments, and each department has about 12 supervisors each, and those supervisors have about 12-18 employees…
-
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...)…