-
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…
-
Producing a chart on a dashboard to show resource capacity
I have created a report with information about task status and owner for a bunch of projects. I am trying to summarise this on the dashboard as a pie chart (ideally open tasks by owner); however, the chart shows the same owner multiple times in different colours because they have outstanding tasks for multiple projects. Is…
-
Why is the Report function not picking up data from one of the source sheets?
Hi all, I'm currently using the Reporting function to create a Programme Risk Log for two projects (Project Sample A1 and Project Sample A2), each of which is using the same template Risk Log. As you will see from the screenshots, both Risk Logs are selected in the Sheets tab for the Report in question, however only data…
