-
Reports - calculating the gross margin rate
I am using Reports to bring data from multiple sheets in a project, but i need to calculate the project GMR (gross margin rate), how can I do this??
-
Can't move primary column in reports when using a Group
Hi, I've built a simple report in which I don't want the primary column to be first. After arranging the columns in my desired order, if I add a Group the primary column moves to the start and cannot be moved afterwards. Does anyone have any ideas?
-
Transferring Ownership of Multiple Sheets/Reports/Dashboards at once
Hello, I've got a scenario where I helped a user (let's call him User 1) create a process, however, he (User 1) has switched positions and it is time to reassign ownership of things to another individual (User 2). Between me and the original user (User 1), we created all the sheets, reports, and dashboards in the…
-
Report suddenly stopped showing any rows
I created a report that points to many different Workspaces. I used filters to control which sheet names are shown on the report. Yesterday this report was working perfectly. This morning it's not working. Any clues?
-
View All Comments in a Report
It would be nice if you were able to view all comments in a report similar to when in a sheet. You have to go row by row to see each comment individually. A tab with all comments would be helpful.
-
Reporting from worksheet with heirarchy
I have a worksheet that has parent child relationships. I have created a couple of 'helper' rows ('HELP-Phase' and 'HELP-Phase 1') to aid areport in illustrating the parent child relationships (i.e., group by one of the 'helper' rows). The % Complete and the date columns are not displaying in the 'group' heading. I would…
-
Smartsheet PDF Exports Break Links Over One Line?
I am having an odd issue in using Smartsheet and exporting Reports for the first time. I created a report from one of my sheets, with one column that includes a hyperlink. It's a pretty long link, but the text is wrapped so it simply splits the link up with a line break in the export. However, the actual HYPERLINK that it…
-
Combining SUM and RIGHT
Hello, How may I find the SUM of multiple columns by using the SUM function and RIGHT function? I am collecting the data via a Smartsheet form and will need to email out the call center representative's score to their managers. I am getting #UNPARSEABLE as the result. Can someone help correct me? A1, Customer…
-
How to Avoid Having to Select Each Sheet for Report Inclusion
Has anyone found a way to provide Smartsheet a list of sheet names to include in a report or a filter based on Sheet Name that can be used to include / export from Reporting? It is extremely tedious to manually select each individual sheet to include in a report when you have 100+ projects from which to select from. Thanks.
-
Dashboard Chart shows "No Data to Display" for 0 values
Hello, I have looked at a couple other questions about this already but I cant seem to understand how to fix my specific situation using those answers. I have a Column chart with an X and Y axis on a Dashboard. The chart itself is being filled by a Report filtering the last 30 days. The "Created" and "Score" columns are…