-
Can you move the grouping in reports above a different column?
I am trying to report on sheets with different primary columns so I want to hide this in the report but doing so hides the grouping as well. I tried changing the column order before adding the grouping but then it reverted to having the primary column on the far left.
-
Banded Rows for Reports
It would be nice if reports created banded rows automatically instead of having to create complex formulas in the source sheet to band rows that flow through to reports. Most of our reports come from one master sheet. If I create banded rows based on one set of criteria, it works great for that specific report. However,…
-
Trying to consolidate specific rows from multiple sheets into one
Hi, I currently have 11 project plans and I would like to consolidate specific rows (e.g., rows related to a specific system) within those plans to a master plan, where I would add additional columns to edit. I looked into reports and linking cells, but these don't seem to do what I need. The consolidated report should be…
-
Many columns on sheet - not all appear as options in a report?
Happy faux Friday! I'm working with a very large (about 30 columns) data sheet in Smartsheet. I'd envisioned it as the one source of truth to feed multiple reports. The problem is the latest report I'm trying to build, the 5 columns that I need to appear and provide data, are not showing up in the columns from which I can…
-
API endpoint for summary information reports
Currently when using the Smartsheet connector for Power BI, is not possible to grab sheet summary information reports, only reports based on sheet row line information. It would be very good to be able to gather information from summary based reports on Power BI.
-
Column Name Change Doesn't Break Report
I could be dreaming but didn't Smartsheet fix the issue where changing a column name breaks reports? Did this get released and then rolled back or am I imagining things?
-
Search Reports for strings as well as Sheets.
need to be able to find report when searching for strings such as ID numbers.
-
How can i set up portfolio level dashboard report in smartsheet.
In smartsheet how can I set up portfolio level report and same time I can integrate with Resource management for actual effort calculation.
-
Sharing a Report
I have a Smartsheet that I would like to share with employees and customers. No issue sharing with employees, they can see everything in the sheet, at anytime. The Smartsheet is being created from multiple data shuttle workflows, so there is some manual sorting and changes that must be done before the sheet can be shared…
-
Networkdays/Workdays Excluding Holidays and Exceptions
Hello, I am having multiple issues with my calculations for NETWORKDAYS and WORKDAYS working in Smartsheets. I entered default holidays into the Non-Working Days (holiday, exceptions) box in the Account Administration field assuming that once I set up the holiday/exception dates Smartsheet would deduct these dates from the…