-
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…
-
Embed Web Content (Internal Website) on Dashboard
Hi Community ~ I'm trying to embed web content (from an internal company website) on a dashboard. We have added it as a trusted domain in Admin center and enabled the web content widget in security and controls. I was able to embed it but it won't display. I get a message saying that the domain (which is an internal…
-
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…
-
Use report count value in dashboards
Hello, I am new to Smartsheets. I have tried searching in the forums, but couldn't get a resolution. Below is the scenario. In Folder - Project Type 1 Project 1 Project 2 Project 3 Using Summarise function of a report, I can get the count of number of projects in each folder. Can I use this count value in a Grid or…
-
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…
