pdf and excel files into multiple sheets via Gantt?

edited 12/09/19 in Smartsheet Basics

Hi there, trying to make a production line more efficient and I need to attach a file to each order (each order is a separate row). We run off of multiple sheets, and have reports broken down to each department.

For example:

Main Sheet: Gantt Production - includes all orders (which are linked to multiple reports)

Report: Saw Production Report - shows the order from Gantt Production (pulls the orders only directly going to Saw)

So right now we need everyone to be able to see attachments for each row. Is it possible to attach them to a master sheet and somehow link the two instead of attaching to every individual sheet?

Hopefully that makes sense :)