-
Report not pulling from one of the selected pages
I have created a report for my boss called the "latest comment report". It pulls the latest comments within the last two weeks from all my active project sheets. It is working great for the most part, however the report is not pulling the latest comments from one of our project sheets. All active project sheets have a…
-
Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
-
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.
-
Create a Report Widget with an option to Export not Web Content
This is a REPORT WIDGET screenshot. This loads instantly when I open the dashboard even with many data entered (screenshot doesnt have any right now). It does not have an option to copy text or export the file. This is a WEB CONTENT WIDGET, using the REPORT Publish link, I was able to display it. It has the option to copy…
-
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
-
How can I make FS dependencies start on the same date the predecessor ends?
Hi everyone, I’m migrating a schedule from MS Project to Smartsheet and I noticed a difference in how FS (Finish-to-Start) dependencies behave. In MS Project, when a task has an FS predecessor, the successor’s start date is set to the same day the predecessor ends. But in Smartsheet, the successor is pushed to start one…
-
Creating Line Chart Across Quarters
I’m trying to build a dashboard that shows a line chart of average quarterly survey scores for each recruiter. Here's what I want to achieve: Each line represents a recruiter. The X-axis shows quarters (e.g., Q1 2025, Q2 2025, etc.) The Y-axis shows the average survey score I want to visualize trends over time for each…
-
Dashboard of dashboards
I need help please. Can you please guide me on creating a dashboard for a manager to access all his team member's dashboards in one place.
-
Resource Management Utilization Report Enhancement- Project Tags
It would be helpful if the Resource Management Advanced Utilization Report, Tag Filter, measured against the resources (individual & discipline) total available hours rather than against the project's allocated hours. From an organization's perspective, we are looking to understand total utilization for our teams and…
-
Permissions added for a user without a license aren't taking
I have a user that doesn't have a license, but needs Viewer permissions to a workspace, and some Editor permissions for specific reports. When I set this up in the past, it worked great, but today, it's not working any longer. Has something changed around how permissions are supposed to be setup?