Aligning Columns in a Report that is pulling Data from Multiple Sheets

Berto D

I have a Primary Column in two sheets with the same data - Project IDs.

The subsequent columns are different, however.

One sheet has team members info.

The other sheet has budget info.

Can I create a report that pulls from both sheets, and the Team Member info is side-by-side with the Budget information?

As I understand it, if I merge two sheets into one report, Smartsheet will place the data from one sheet underneath the data from the other.

Is that an unavoidable structure to Smartsheet's report?

Appreciate the feedback. Thanks!

Darren Mullen

@Berto D Yes, that is unavoidable, because each row in a report represents a row in a sheet. Now, what you can do is pull in the Budget information into the Team Member sheet based on the project ID so that the budget information would be on the same row as the Team Member information.

Berto D

Yup, that's what I thought. Thanks for confirming.