Generate Report per Row

Jamie Gamauf

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?

J. Craig Williams

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

Travis

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

J. Craig Williams

Travis, that is a fantastic suggestion. 

Oh, the wheels are turning! Thanks!

 

Craig

Mike Wilday

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.  

Mike Wilday

Nope. Only works with Google Docs.