-
Text wrap in grouped report fields
Hello! First of all, I want to say that I love the new grouping function in the report builder. It's a game changer. I'm having trouble, though. In one report, the fields I'm grouping on are text fields, and they can get quite long. The underlying sheet has text wrap on for those fields, but that formatting does not carry…
-
Can I pull a report based on who has access to specific reports/dashboards for governance ?
In line with GDPR, I need to be able to pull monthly reporting on who access access to specific sheets. Is this possible?
-
Sheet summary - column formula
Hello, I am creating a smartsheet that aggregates the clubs that certain employees are in. That main component is done, and I am now using the sheet summary function now (mostly using COUNTIF) to link to a dashboard. However the number of entries on the sheet will change with new employees, which makes the sheet summary…
-
Hyperlinks in Reports
Hi, On the first day of each month, I send a report listing all documents published in the previous month. The report includes hyperlinks to each document's location. Before the recent Smartsheet changes to reports, I would email the report with the active links; however, the email no longer includes the links. How can I…
-
REPORT BUILDER REMOVING UNKNOWN SHEETS IF EDITED BY NUMEROUS ADMINS
Reports no longer show "unknown sheet" placeholders that the current user is not shared on If he/she edits the report builder on a Report that includes sheets he is not shared on it will remove those reports. Please bring back the placeholders so that the sheets added to the reports don't get deleted. We have multiple…
-
Creating Reports for just the current month
Is there a way to create a report that only displays this month. I know there is a way to show X days in the past, future, etc. I have a formula in my sheet that shows the month number to be able to find the current month number, but I don't see the ability to display only that data?
-
How do I show child AND PARENT rows in report?
I would like some help on how to show parent and child rows in a smartsheet report. See this loom recording for more context: https://www.loom.com/share/b55c7ed651994c2d8cfbbf1ed0d04665
-
Parent/grand-parent rows in reports
Hello! I have tried to follow steps in other posts, but my brain cannot figure it out :) Could anyone help me identify the helper formulas for pulling parent cells into a report? I need to pull in to a report the Goals and Problem Statements for any Projects that are identified as "Must Have". So I am trying to figure out…
-
How to Round up date from delta for dates
I have a spreadsheet where I've gotten the Delta (time between end date of task 1 and beginning of task 2). it comes out as an integer instead of a whole number to reflect days. How can I use the ROUND function to reflect whole integers? An alternative: is there a setting within the Smartsheet that would allow for whole…
-
How do folks sort by (alphabetical) month in a report?
The new reporting tool is great, but the grouping feature seems to conflict with sorting. I have already had to build extra columns to show month as a word (i.e., January). Now to sort by months of the year, I am kludging some things that are painful when other tools like Excel have such flexibility (up to a custom sort…