-
Darstellung von Meilensteinen: Unterschied Blatt/Bericht
Ich möchte Meilensteine über einen Bericht wiedergeben. Werden die Meilensteine und ihre Abhängigkeit auf dem dazugehörigen Blatt noch korrekt dargestellt: fehlen diese Informationen in meinem Bericht. Wie erhalte ich die vollständigen Informationsgehalt auch im Bericht? Dieses Ergebnis ist schlecht lesbar und…
-
Row Report - Multiple Sheets - Remove Duplicate Rows
Good afternoon, I am working on creating a row report using multiple sheets of mostly the same data. Starting with sheet one, at sheet 2 the row is 'moved' and more data is added and sheet 3 the row is copied and more data added. I have created the report pulling all the data in, and was able to find a filter successfully…
-
Group Management Reporting Capability
I would like to be able to run a group report showing all the group names as well as those who are included within the groups.
-
Report: Right-Click Header, "Group by this Column" and "Summarize this Column"
In Reports, It would be GREAT to be able to right click on a column header and add that column as a group or a summary. The options would be: 1. Group by this Column 2. Summarize this Column And then when you go to the GROUP or SUMMARIES menu, you can then select how you want it summarized or grouped.
-
Ways to find what reports are running a certain sheet as it's source data
I want to make some structure change to particular sheet. (Especially Primary column) However, before I can change that, I need to find out how many and what reports are using this sheet as it's source to make sure nothing will break. Anything used in cross-sheet reference formulas are easier to find out but Smartsheet…
-
How do I change the columns on a task rollup report?
I'm trying to replicate the Task Rollup report that is available in the Smartsheet templates. However, for reasons I can't figure out, I'm unable to get different values for the Status column to populate the columns like the template does. Instead, it imports every task in the base file and it's respective status as rows.…
-
Reports Duplicating Columns with Identical Column Names
Happy Monday Community! I am building a report, and I am trying to understand why I am getting column name duplicates when they are exactly the same. Both sheets are built off of a template so they should be exact matches, and I checked both sheets and the column name spelling is exactly the same. I even copy/pasted from…
-
Wrong date pasted when copying "Created date" to "Date" field in Report
Scenario: A sheet used to track customer request fulfillment has both a manually entered "Date" field and an automated "Created date" field. The idea being if needed, you could enter records after the fact and still track the correct date for reporting. The data needs cleaning. I created a report for staff to easily see…
-
Current User Filter
Hi I have a report that is filtered by current user. The sheet contains requests people submit via a form. I have set the form that allows submissions without the user being logged into smartsheet and this appears to be now giving them a number (see screenshot of filter below) This is now causing my report filtered on…
-
Assets and Workspaces Use - Dashboard reporting
Anyone familiar with the Admin center has the chart that displays the total asset count per account (workspaces, sheets, reports, dashboards) pictured below. I'd like to generate a month over month view of these metrics on our company dashboard to show the growth/use of Smartsheet for our leadership team. We are newer to…
