-
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…
-
#BLOCKED / Auto-Save Issue in Project Billing Forecast Report
We are still facing a critical #BLOCKED / Invalid Value issue in our Project Billing Forecast Report. 📌 Current behavior: In the underlying Sheets, formulas (e.g., Total Billed This Period, To Date Billed) initially show #BLOCKED/Invalid Value, then refresh to correct numbers. However, the Sheet does not auto-save this…
-
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.
-
Provide users with the ability to Print a Grouped Report
Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable. We've stopped…
-
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…