hi
I run a smartsheet where users create smartsheet sheets to plan individual projects.
I have a list of all the sheets required.
I want to pull a report that compares the list of sheets required with the sheets actually created to track progress.
I can create a report which pulls them in as pairs of rows (1 line from project sheet, 1 line from list of sheets required) but I want the data on a single row, not on pairs of rows.
I cannot figure out how to do it, any suggsetions?
(There are 1000's of sheets required so manual intervention isn't ok!)