-
Dashboard Report Issue - Report not showing data
Hi Everyone, Looking for some assistance on a dashboard report issue I am running into. I have a dashboard with 3 reports added as Web Content. All 3 reports use at 1 common sheet. All 3 reports are published as read only. Users are not shared the underlying sheets. All 3 reports have some form of filtering. 2 of the…
-
Smartsheet Filters
I’m hoping you can help me out with a question regarding Smartsheet. We have created a exception report within Smartsheet and I am having an issue with a client row being recognized when a filter is placed on the particular smartsheet. For Example: on the Exception main page you have 50+ clients listed with all exceptions…
-
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
-
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
-
Make it so that a dashboard and all its components (widgets) belong to the owner of the dashboard.
Currently, a dashboard's components do not belong to the dashboard's owner. If another user adds or edits a widget on a dashboard, that widget does not belong to the dashboard's owner. Instead, it belongs to the person who added the widget. This means that if a dashboard changes ownership, the dashboard will break when the…
-
Does anyone use a Change Management Form in project work and have a dashboard?
Hello. Our PMO is beginning to use smartsheet as our primary tool. We're starting with basics and have created a project plan template that also rolls up into a dashboard. We would also like to track change requests and have an overview for reasons, # of requests, # of date changes made due to requests, etc. Do any of you…
-
Return blank when count total is zero
Can you give me a variation of this formula that delivers a blank if total counted is 0? I want to use it in forward months so I don't have to update the metrics sheet monthly, if possible. Thanks, Lisa I tried the IFERROR and IF(COUNTIFS( I could find but most deliver Incorrect Argument. =COUNTIFS({4Q2025 FPG thru Oct…
-
Using Analyze Data to create Charts
I'm working on creating Dashboards and I don't want to have to create 100 Sheet Summary formulas as I'm trying to have the Analyze Data create a Chart to show me how many times a certain letter shows up (K,SP,P and U) and it creates this which is showing all of the rows that are currently on there not the ones that have…
-
Sharing form links via a dashboard
I've created a Dashboard with links to all of the forms that employees may need to submit (mileage reimbursements, equipment check out, injury reporting, etc.). If I share the dashboard with an "All User" group will they be able to access and submit all of the forms on the dashboard?