Common List

Paul Remke

Smartsheet newbee here...so bear with me...

I'm tying to create a common list of systems of which there a multiple scopes of work associated with a each system but not really related ot each other....therefore, I would like one sheet which simply lists all the systems, along with basic information....then another sheet which links the list in the first column of the first list, which then aloows me the have specific information for that scope....sounds simple.

The issue is, I will need to periodically ADD lines within the first systems list sheet. How can the lines be automatically inserted in the other, linked, sheets? or is there a better way to do this?

or am i mssing a simple way to accomplish this?

Mark Cronk

Hi Paul, I think you're better off keeping everything in 1 sheet. You can use reports to filter the information and present pieces for easier viewing and navigation. You can have a report of summary data and one for detail.

Mark