Linking Sheets

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?

Find more posts tagged with

Sharing and Collaboration

Formulas

Services

Cell linking

Comments

Mike Wilday

Smart sheets does not currently have this capability.

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?

RichardR