Can I create a drop down list that is auto-populated based on values from a column on another sheet?
Alex Hackford
✭✭✭
I would like to create a drop-down menu column on one sheet with values that are auto-populated based on the values in the 'event name' column on another sheet. The goal would be that when a new row is added to the 'event name' column on sheet 2, the drop down on sheet 1 then includes that new row value.
Best Answer
-
Hi @Alex Hackford ,
Unfortunately, you can't populate a drop down from another list. Dynamic dropdowns sounds like a great suggestion though. You can submit it as an enhancement idea using the link below.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Alex Hackford ,
Unfortunately, you can't populate a drop down from another list. Dynamic dropdowns sounds like a great suggestion though. You can submit it as an enhancement idea using the link below.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
You can use a 3rd part tool called ddup. It is actually reasonable priced and easy to setup. I use it and it works great. I website is ddupdate.com.
-
@Lynette.Smith,
I'm curious if you have reached out to DDUPDATE.com to ask what information they can provide to ensure security with their app? I want to use this for my PMO but am reluctant to because of security reasons.
-
i recently learned to use the data shuttle offload and then upload function for the drop down list to be populated from sheet to another
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…