-
Show parent OR task at same level as parent in report
My past due report was showing the naked tasks without context, so I wanted to add the parent. I added a helper column with '=(PARENT(Tasks@row)) and grouped the report by that column. That works for some of the items, however here's the issue, some level 3 items have sub-tasks and others don't, so some tasks are at level…
-
Why does a report show up blank on mobile device
Why does a report when accessed via a mobile device like the iphone show up blank unless the viewer selects the button #2 at the top. This can be very confusing for people not familiar with SS. Any way to force the button #2 to show by default? I assume if I embed on on a dashboard it would correct this but why do this…
-
Edit Reports Sent as an Attachment
Not exactly a new idea... But, something that would make my life easier. I have reports set up to send as an attachment to our client weekly. The distribution list occasionally changes. When this happens, I have to delete the schedule and start from scratch. The only thing I can edit is the schedule of when it is sent and…
-
Cross Reference Report - Workaround Ideas
Hi, I know that I cannot cross reference a report; I'm hoping someone might have an idea on a workaround. I have a report that gathers data from all sheets in a specific folder. The quantity of sheets varies around +/- 200. I want to get one summary field (to match on) and the sheet link from each sheet into another sheet.…
-
Cumulative record of live sheet summary reports
Hi everyone, I have a sheet summary set up on every project, which tracks a number of weekly KPIs - e.g total tasks that week, total completed that week etc. The sheet summaries feed into a larger sheet summary report which shows these KPIs, but only for this week. I'd like to capture the info in the sheet summary report…
-
Merged: Report Totals Printable
This discussion has been merged.
-
Contact Formula from Latest Comment Column
Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, if/when they are added in the latest comment. I currently can move (1) email but not multiple ones. I then put it in a helper…
-
Modifications to Internal Communications Template not showing when building reports
Good morning, I am currently working with the Internal Communications Template to create a Planner for our Learning Communications. I needed different Categories and delivery methods so I edited that information the Internal Communications Plan Sheet but when I try to use the summary reports in the template or build new…
-
Need help with a master report to create conditions within a calendar.
I am trying to create a master report where it shows vacation days for the team as well as due dates for the projects they are working on. With that being said, I would like for the start/end date to show on the calendar for vacation, but ONLY the end date to show for the projects since they are usually pretty long…
-
Attachments in Reports
Is there a way to include attachments on a row in a report that is being sent as an attachment? We have an issue tracking system set up in Smartsheet, but have been directed to move it to Jira. We can successfully create a report with the necessary information, but I'm not sure if the attachments can be included in the…