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.

Jesse G.

If you are able to set up data shuttles, you can use an offload data shuttle to save an excel file as attachment to your sheet and you can set up an upload shuttle (running on attachments) to update the dropdown on a selected sheet and column.

If that could help you let me know and I could help you set it up.

Edit: If you mean by Regular Smartsheet, no data shuttles, I don't know if this is possible.

Andrée Starå

https://community.smartsheet.com/discussion/139572/is-there-a-way-to-have-dynamic-cell-updates-my-previous-attempts-were-unsuccessful

Hi,

I hope you're well and safe!

You would need the Premium App, Data Shuttle, or similar.

More info:

https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

Is that an option?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

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.