Is there a way to have dynamic cell updates? My previous attempts were unsuccessful.

denkeis

I have two (or more) sheets, one sheet called “Master Sheet” and another called “Library 01”. I want to create a drop down in Master Sheet with Options “A-H” which populates data from Library 01 and automatically changes based on the option chosen from Master Sheet. Is regular Smartsheet capable of this?

I've tried using things like: =INDEX({Library Description Range}, MATCH([Phase]@row, {Library Phase Range}, 0))

However, it seems to need to be updated manually if anything changes or a different dropdown is chosen.

Paul Newcome

@denkeis In addition to Data Shuttle, this can also be achieved using the premium add-on Bridge, the API, other similar third party apps, and we at 10xViz also offer a dropdown column manager to accommodate this.