-
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…
-
Need a report of the Jira connector users usage
Hi Team, I was asked about the amount of users that are using the Jira connector to Smartsheet. I know that in the user management report there is one role called Jira Admin but we need the users that are collaborating with the Jira connector. This is important information to understand how much important is the JIRA…
-
Chart Widget in Dashboard not separating data when creating charts.
I have a report that pulls in data from several sheets to summarize the yes and no columns. When I add the information to the chart widget I would like to see a group over group of 2 columns, one for Yes in this class and one for No in this class, and then see it class over class. Whenever I add the report to the chart, it…
-
Automation for Reports
Good day, My department currently has 2 Smartsheets and 1 report for processing requests from external users. These sheets are not public, and the governing bodies are against making them public due to internal conversations documented on the sheets. We would GREATLY benefit from automation in this process, but the…