-
Dashboard Chart Display for Amounts and %
We created a dashboard that includes a chart from a sheet summary report. However, while the total records are correct, the % is not (i.e., the 1st Meeting total is 67, but it shows 47%, which is not accurate - it's actually 12% of the total). So, I created another summary field to calculate the correct %, which works, but…
-
Dashboard Automation
Is it possible to set up a dashboard automation so the link to the dashboard is sent out daily?
-
RYG ball to determine priority involving multiple dates
I have a sheet that lists all active contracts for my department which all have expiration dates. However, I am struggling with this sheet because in all calculations I need to consider any extension dates. I do fine with calculations when there is one date involved but when I need to write them to incorporate two and…
-
Can a Master Dashboard automatically pick up a new Master Smartsheet links?
Hi, I have created a Master Dashboard in a folder with a Master Smartsheet and Reports - at risk tasks, Project Milestones and Status. My question is, if the dashboard widgets are always pulling data from the Master Smartsheet or reports and the reports are also pulling from the Master Smartsheet, can I just swap out the…
-
Monitoring Workload without Resource Add-On
Hello- I am managing a project in Smartsheet where I need the ability to conduct ongoing monitoring of resource hours for tasks per week. The use case is for the PM to use this info to ensure the estimated times of tasks assigned to a given individual don't exceed that person's availability cap (That data is stored…
-
How to Design My Smartsheet App
I work for a Hospital and I am creating an application to track employee health details such as vaccinations, annual health reviews, health exams, etc. For example, employees are required to get a flu shot each year or a waiver. Employees also have to take certain tests when hired such as a chicken pox test and a color…
-
Is this a glitch?
Hello, I got feedback that this chart needs to be 100%, not 101% :) Any idea?
-
How to remove user access for specific dashboard without effecting Workspace?
Hello, How can I remove an unlicensed user from specific dashboards without having them lose access to the workspace? Thanks,
-
Reports vs. Sheet (reporting / dashboards)
I am struggling because I have a very large SHEET that has many many data points that I have created a REPORT to create a BUDGET summary and projects for Quarterly Portfolio review(s); however, NOW I have to create a REPORT from this REPORT so I can create WIDGETS / Charts on a Dashboard; however, I know it isn't a thing…
-
Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding So, the first few-ish sections will…
