-
Count and Lookup - based
Experts, I need to count the values of each column excluding Today Value. Rest of the Yesterday and Blank values of respective columns like #New Hires, and drop the values in the 2 Yesterday Metrics. It is pretty easy to do a vlookup for Today, but if I need to cumulate the Yesterday and Previous day values. How do i do…
-
Be able to export large reports > 20000 rows
Report does not display detail lines in Grid view if it's beyond 20000 rows. However, it does display it in Table (preview) mode. I would like the following 2 enhancements to make viewing the reports easier: Be able export detail lines regardless of the limit. Provide export option in Table (preview) mode.
-
Merged: Add Monthly Flexibility to Incurred Hours Reporting in Resource Management
This discussion has been merged.
-
Incurred hours not showing for future dates within the same month
Hi everyone, We are using Smartsheet Resource Management for capacity planning, operational follow‑up, and monthly financial reporting, and we have a recurring challenge related to how Incurred Hours are handled in reports. We understand that incurred hours are date‑driven (past vs. future), and that this behavior is…
-
Lookup Value and Count based on the input criteria
Hello Team, I am trying to bring a formula to look up a value and bring the corresponding counts. The input sheet will look for the "Date of" column and dynamically generate the Yesterday or Today value based on the formual i have written for "Yesterday/Today" column. There is a person going to enter #New Hires, #Leavers,…
-
Dashboard not showing all information
I have a report that is showing tasks with their end dates and I have a filter to show only those tasks where the end date is overdue or due in the next 14 days. This works fine in the report however in my dashboard (using report widget) the end dates for the overdue tasks are showing fine but the end dates for the tasks…
-
Merged: Enhanced Report and Sheet Filters for Dates
This discussion has been merged.
-
Adding in new reports via global update
Hi all, Weird problem I am facing today and wondering if something has changed. I have run global updates in the past to push new reports out to active projects (its very nuanced with having to update the report for each project individually) but anyways… Today I tried to run one and the test example worked fine with…
-
Merged: Reports - filter with parent rows
This discussion has been merged.
-
Merged: Sheet Filters in Filter Groups
This discussion has been merged.
-
Merged: Reports - Print PDF with Groups
This discussion has been merged.
-
Why is sort by date not working right?
Hi, For some reason, using sort dates, my report has put January 2027 before any 2026 dates? Conditional formatting it set up to be red if not complete and past date, hence the 2027 row being the only white. Thankyou in advance!! :)
-
How do I run this report?
I have a sheet where there are several different "Assigned To" columns and then a "Project Status" column. I need to create an employee workload report. Each report should only show that employee's assigned to tasks that are in their current status. For example: Deron's report should show the row Project Name and Project…
-
Seeing data in a report
Would someone need View permission to a worksheet in order to see the data presented in a report?
-
Timeline Integration from Smart Sheet Report - Bug?
Has anyone had issues using the timeline feature built off from a grouped report? Having issues with viewability and when I edit things look how I would expect but after saving many of the timeline views are blank. GIF attached shows how it is currently functioning and how the view changes when in edit mode vs. not.…
-
Merged: Help Text from Sheets on Reports
This discussion has been merged.
-
Managed vs Unmanaged Resources Utilization Reports
I have linked my Project Plans to Resource Management but the Utilization report in Resource Management is only showing me the Managed Resources and does not show me the Unmanaged Resources. Is there a way to get this Utilization report or view without having to buy Licenses for all these Resources who will not use the…
-
Click-Through Capabilities for Smartsheet Calendar
When publishing a calendar from the Smartsheet Calendar widget to a dashboard, users can still slick through to a calendar list via the header in the calendar. There should be a way to "lock" the calendar view to a published dashboard that prevents users from clicking-through to other areas. This "locked" calendar should…
-
Edit Access for Some, View Only for Most
I have a large master sheet that I do not want anyone to have access to except the small team of admins. Is there a way for everyone in a dept to see the projects their dept are involved in (this is defined by a column), but only the PM can make edits to it? Bonus points if we can sort by "Status" then by "Kick-Off Date".…
-
I am stuck in view mode but I have editor access level how can I be released from view mode and back to editing the sheet
Hello I share my sheet with a fellow member to add and do task to update this sheet they were editors to the sheet but something happen where now they can only view the sheet and can not in put any information to the sheet what I erase them from the group and updated the app but once he got access to the group again he…