In my Row Report, I’ve selected two source sheets. Each sheet has rows that meet my criteria, and both contain a common unique ID column.
Currently, the report displays four rows total (two from each sheet) — Smartsheet stacks them one after another.
What I’d like to achieve is to merge the rows with the same unique ID from both sheets into a single row within the report (essentially combining matching data side by side).
I’m aware that I could combine the data from both sheets into a single master sheet and then build a report on that, but I prefer not to merge the data into one sheet — I’m looking for a way to do this directly within a Row Report, if possible.
Is there any built-in feature or workaround within Smartsheet Reports that allows combining rows from multiple sheets based on a UID?
