-
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.
-
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…
-
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?
-
Printing Reports
I would love if Smartsheet would add the option to print reports with filters. For example, I broke KPI's based on goal number and wanted to bring the report summaries by goal number which isn't currently an option. It would make sharing data with other much easier.