Pull dropdown menu options from one sheet into another based on a defined cell

Miriam

Hello,

I am curious if there is a way for Smartsheet to populate a designated column in one sheet with dropdown options from another sheet based on the conditions of a cell in the sheet the dropdown should appear in. For instance, if Sheet A has a specific value in the cell, you can pull in the dropdown menu from Sheet B into a different cell in a corresponding column. So, something along the lines of "only show me the dropdown options of Sheet B, column 1 IN Sheet A, column 5 IF Sheet A, column 1 has the value X" I have a picture too of what I'm thinking I'm trying to do. I want to be able to select options from the dropdown list of a column in Sheet B that is feeding into Sheet A. Thank you!

Darren Mullen

@Miriam Nothing built into Smartsheet Core. If you have Smartsheet Bridge you could work something up, or there is this Dropdown Manager available that may do what you want, if I follow your example correctly :)

https://www.youtube.com/watch?v=IDMe0vjBCck

Miriam

Thanks, Darren. I was hoping there'd be something built in. I appreciate your response!