Report to show columns as rows in a report

Gregory Zalecki
Gregory Zalecki ✭✭✭✭
edited 09/16/21 in Smartsheet Basics

Looking for a way to have columns on an intake sheet to display as rows in a report.


For example the columns show a breakdown of a product. The sheet shows multiple products. Looking to create a report organizes the columns into rows so the report will just show the breakdown of an individual product.

Answers

  • Hey @Gregory Zalecki

    This is a great idea, and although we don't have a dedicated feature for this yet, you may wish to raise an Enhancement Request using the Hamburger Menu (3 vertical lines) in the top left of this page.

    I feel this would have to be more of a manual creation, or alternatively, if you have access to the Pivot App, you may be able to create something.

    Below is an example of what I've created. The rows consist of the Project Name, and the Column Headers are for those who are assigned to a Project. Please note that the blue lines are covering Email Addresses , so I've removed these:

    Kindest Regards

    Sean