-
Metric Sheet for dashboard
Hi, I am working on a dashboard with a Metric sheet. I have the formula to count my tasks =COUNTIFS({Emerald Workflow - Status}, @cell = "completed"). What I would like to do is add in only if date submitted or completed in the last 7 days. the Date Submitted is a system date. Is this something we can do? Kirstie
-
Report in Dashboard - how to disable the "open report" link?
Hi all, since some time there is an open "open report" link under each report in the dashboard. But the user should not be able to open the report, how can I disable this? Thank you
-
Row Count by Department
On my sheet, I have a Department column that is filled in on every row. There are about 1200 rows total. Some example departments are: Accounting, AP, AR, Benefits, etc. In addition, every row has a Status, Start Date, and End Date column filled out too. I have a dashboard for this sheet. I would like to add a bar chart…
-
Current User on Report
Hello, I tried to search for this but didn't find anything that could help so I was hoping somewhere here can help me. I have a report that looks at data and returns a date, shift, current user, and then it groups the results by date. The problem that I having is that when I add that to a dashboard so that people can see…
-
New Dashboard Layout has changed all of my existing dashboards
I know that smartsheet has changed the way dashboards work and is supposed to be more user friendly. up until last month there was an option to keep the classic view or new view. I am not able to see that option any more and it defaults as new view. the issue is for some reason, the side-by-side data widget splits the…
-
Published Dashboards & Attachments via One Drive
Is anyone else having issues w/ the new Dashboard UI? This started no more than a week ago. I maintain multiple published dashboards and share them to subcontractors outside of my network. I attach documents from One Drive to the Dashboard using the shortcut widget w/ One Drive. The documents I'm attaching are PDFs & I…
-
Adding Partial reports to Dashboard not working.
I am trying to add some portions of a report to a dashboard to build a chart but when I go to add data, it will only allow me to choose the entire report. I havent used smartsheet in a few months but I could of sworn that I was able to pick data points within the report to chart. Is this normal? I was thinking maybe its a…
-
Saving Dashboard as PDF
Hello Everyone, I am facing an issue with the page setup while saving the dashboard as pdf in the new version. The size of widgets on the dashboard keeps on changing to a smaller size. For reference, I designed the dashboard to cover 15 pages, but when I print the dashboard using Ctrl+P or File menu, it converts the…
-
Dashboard Charts
Hi I'm trying to create a graph to show the number of hours per person per day. I've tried every type of graph on the dashboard but none will show the data from the report?! Why? What am I doing wrong? Never had a problem with charts before! Report: Dashboard: Super frustrated at the moment as even the simplest of things I…
-
Why am I struggling to embed Powerpoint slides into dashboards using the Web Content Widget?
Hi there, I'm struggling to embed/share MS powerpoint slide decks in dashboards using the Web Content Widget. Can't work out what I am doing wrong or if there's a bug with Smartsheet. I have the files located in Sharepoint, with all share permissions set correctly. I have tested this by accessing the share links from…
