-
Live Dashboard Help! Data not interpreting correctly
Hi, hoping somebody can help with my below task: I currently have what is considered a 'master tracker' sheet for multiple (100+) projects, with several other columns for target dates/owners/SLA's etc, so it is quite complex. I am trying to find the best and most efficient way to pull selective data from 2021 onwards…
-
Reports as Metric Sheets
Hi there, Is there anyway to use a Report to make chart widgets on a dashboard? I would normally create a metric sheet and use formulas to count items I wanted to illustrate in chart form, but have not been able to do that with a report. I have one report that contains over 90 sheets and really don't want to have to build…
-
Viewing Calendar on Mobile App
Hi Smarties, Out of curiosity, is this happening to you guys? I have published a calendar in a dashboard (let's called it Playground) - using both Calendar view and Calendar App. It works great on the desktop, but I am getting the below icon on the mobile app? Is this happening to anybody else? Is this a bug or something I…
-
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…