-
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.
-
Report Doesn't Have the Option for Grouping, Sorting or Filtering
I have a report that is referencing a control center program. Other users that are setup as leads on the program and have the same admin permissions I do are able to edit the Group, Filter, Summarize and Sort settings of this report, but I can not. When I click the Columns button it just says "Loading" and even if I leave…
-
Reports - Need an easier way to view all source sheet from the selection window.
Hello! We utilize a report that has 100+ source sheets. We've discovered a few sheets are missing and I need to cross reference a list of all the sheets that should be on the report with what is already on the report. Is there an easier way to do this besides scrolling through the list of 100+ sheets or having to type the…
-
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…
-
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,…
-
Merged: Add Monthly Flexibility to Incurred Hours Reporting in Resource Management
This discussion has been merged.
-
How are you scaling a PMO in Smartsheet across multiple departments/workspaces?
Hello everyone! We have a great structure within our own department and looking to expand across our firm. I am looking for insights on how you manage cross‑department projects when each department has its own workspace? Interested in workspace structure and reporting best practices. I appreciate the help.
-
Add new filters in Report
Hello, I would love to have in my reports the possibility to filter on "This year", "Next year", and "Last year", according to a date type column. Today we can just define an date interval for example "after 01/01/2023", "before "31/12/2023", and it has to be updated every year. I hope some of you will vote this…