Consolidating multiple sheets into a single report line

Haley Roberts

Hello,

I want to pull a report that compares 2 sheets. Both sheets have the columns and the same primary header

 I can create a report which pulls them in as pairs of rows (1 line from project sheet, 1 line from data sheet) but I want the data on a single row, not on pairs of rows.

 Any suggestions on how to do this?

Colleen Patterson

Reports will pull 1 line of data / sheet, you may be able to use a VLookUp or a reference formula to pull in the exact fields to a rollup sheet to provide you the information you are seeking.

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports