Common List


Smartsheet newbee 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
    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.


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!