Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Generate Report per Row
Is there a way to generate a report per row? I have one project for each row with numerous columns. I would like to create a one page report that list the columns in a vertical format with the data from its corresponding row. Does that make sense?
Comments
-
Jamie,
Smartsheet does not do "transpose" natively.
You could build such a thing using cell links, but depending on row and column numbers, it might take a while.
Craig
-
You could also use Smartsheet Merge to bring this data into a Google Doc: http://help.smartsheet.com/customer/en/portal/articles/1850128-smartsheet-merge-add-on-for-google-docs#merge
-
Travis, that is a fantastic suggestion.
Oh, the wheels are turning! Thanks!
Craig
-
Hmmm. The link was broken: https://www.smartsheet.com/apps/google-docs-smartsheet-merge but this is interesting. I gotta try this with Google Sheets.
-
Nope. Only works with Google Docs.
