-
Portfolio Metrics and Dashboards
Hey all! I just presented the new dashboard solution to the leadership team when I noticed the dashboards aren't picking up anything from the meta data sheet (which in combination with our intake sheet) creates my weekly status report template. Any reason you guys can think of that would make all of my formulas freak out…
-
Looking to Format the report
I am trying to display only one cell with a KPI number from the report, but I am unable to change its format. Any idea how to change format of Report?
-
Dashboard Report view not showing correct Primary Column values
Have many reports pulling from a master sheet which are functioning correctly. But when this report is viewable on a Dashboard, the preview window is not showing the Primary Column values...? In fact, the dashboard report preview is showing a duplicate of a different column values in place of the correct Primary Column…
-
Access to Event Reporting API other then Enterprise plan
Hi, As Event Reporting API(https://api.smartsheet.com/2.0/events?since=2022-01-10T00:00:00Z) is available via Enterprise plan only, Is there any way we can access this API with free trial or Developer account. We require the access of this API for development purpose only. So Please let us know if there is another way to…
-
How to create a dashboard to show increases
I need to track the cost impact of changes per community. We track changes using a CRF # - so for example if I have CRF # 2024-015 that effects two communities, I would like to be able to say "hey, CRF 2024-015 creates a cost change at San Tan 40's Electrical Contract by $589.50 or 13% AND it also creates a cost change at…
-
Cannot deselect "All Columns" in the Columns Included when creating a dashboard from a report
When I click on the x to remove All Columns to select which columns I want included in the chart it will not be removed. Also, when I try to add columns in addition to All COlumns being selected it provides an error- I am trying to build a chart widget that shows a "column" or bar chart breakdown of the count of items by…
-
More Robust Backup Platform
There have been many requests for a more robust Data Backup/offload system because the existing system is inadequate. Smartsheet is simply not a viable option for data management in regulated spaces until: 1. Backups are more easily automated (Can't you just make a Data Shuttle checkbox to prevent replacement of previous…
-
Time/Date Filter for reports
I have a report where I want to filter all items that occurred in the past 24 hours from the moment in time of 06:00am today. Can someone help to guide me in how I would set up the filters in the report?
-
How to create a new row by pasting in data from Excel WITHOUT access to the source sheet?
Hi! I am working with a source sheet that has highly sensitive information, so the collaborators can't have direct access. Because of that, I have created a report where they can update only the rows they are tagged in whenever they need to. However, from time to time they will need to add new rows to the sheet using over…
-
Merged: Dashboard Graphs Improvement
This discussion has been merged.