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.
Single-row reporting from multiple sheets
In the reports I've used so far a new row is created for each sheet data is pulled from. Is there a way of combining the results on one row where the primary column is the same?
For example, if I have project RAG status in Sheet1 and project financials in Sheet2, and both sheets have the identical project name as the Primary Column, can I get the report to show only one row per project with columns from both sheets presented on the single row?
The only workaround I can think of for this is creating a Sheet3 that links to the other two sheets, however for the volume of data I'm working with this is not ideal.