Modified "Report" for client

DLeazenby

I have a contract with 262 units that are being reported into 10 database sheets. The finished product I am looking to have is a sheet with the 262 units displayed vertically with the Projects horizontally, with the quantity reported on each project in the row of the corresponding unit.

I was successfully creating cross references to summarize the unit columns from the database sheets into their correct place, but came to an alert that the cross-reference limit for one of the database sheets was reached when attempting to add the next reference.

I lowered the quantity of units being reported in the database sheet to less than 100, but it seems that the cross references are still there and I can't find where to delete them.

Any ideas or suggestions?

kowal

hi @DLeazenby,

are you so lucky to have PivotTable by smartsheet as feature because it would solve your problem.