-
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…
-
Access/visibility query
Hi been a while since I used Smartsheet but pretty sure this was possible previously. 'Master' list of customers....(admins central sheet of all customers). We then allocate them to 'Agents' - free collaborators that will have a report from the master sheet - showing them only the commercial data for their assigned…
-
What formula(s) would work best for this task?
Hello Smartsheet community! I have a question regarding what formula(s) would work best for a specific spreadsheet I am building. The situation at hand: I have a spreadsheet with data that has been submitted through a Smartsheet form. This data is connected to a users alias and tracks their completion of training. There…
-
# of Tasks Assigned to Each Person from a Folder
Hi All, Working on trying to find a solution to the following. We have a dashboard we'd like to use to understand the workload across all of our standard projects. Specifically, we want to know the number of tasks assigned to each person by health status. The Folder "Standard Projects" includes multiple sheets, and will…
-
Cross Referencing Sheets
Hi, We want to create a sheet that cross references another sheet and only pulls in data relevant to the partner with whom we are sharing the sheet. The reason we do not want to use a report for this use case is that you cannot hide the comments from a report and we do not want them to see the row comments. Please advise…