-
Editable Sheet Summary Report
It would be a good addition to Smartsheet to be able to edit data in Sheet Summary reports, just like we can edit regular Row Reports. I don't understand why the 'two-way' data entry functionality between Sheets and Reports does not apply to Sheet Summary fields.
-
#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…
-
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.