-
How to summarize and visualize sheet summary data of multiple sheets?
Hi! I've been using SmartSheet to track progress of different business units on a particular project. Each unit has its own sheet containing grid data that they fill out, as well as sheet summary data where I calculate different KPIs (e.g. number of records with specific status). For each unit, the sheet summary data is…
-
Auto updating an image in a Dashboard
Situation: I'm creating a dashboard where I'd like to pull in a chart/image created from another platform. I can save this chart as an image, PowerPoint, or even excel file. Problem: I'd like the Smartsheet dashboard to update this image when the dashboard is open or even at a set cadence (1x per day or week), is this…
-
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…
