Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Linking Sheets

edited 12/09/19 in Archived 2017 Posts

I am trying to link two sheets.

The main sheet contains all my essential information, however one column has a list of drop down options.

If the user selects a certain option from the drop down I want certain information to be presented in a separate sheet. 

E.g: If in sheet 1, monthly payments are selected from the drop down menu, I want the name of this client to be shown in sheet 2. 

Is this possible?


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Smart sheets does not currently have this capability. 

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭


    Mike is right about doing it with cell linking (as far as I can think?) It might be possible using Datamesh but depends on the detail?

    However I have what I think is a simple and better suggestion..... 

    Why not create a Report that shows all the Columns of Customer data you wish to see with the query that you only want to see Rows of data where "Monthly payments" is selected? 

    Easier than Cell linking and will pick up automatically? 

    Hope that helps? 


This discussion has been closed.