Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Auto populate data in other columns by selecting dropdown value in primary column
![Dajah](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I'd like to select an item from the dropdown menu in my primary column, and have the two following columns fill with predetermined information.
Example:
We have 100 items. When I select one from the dropdown menu in column 1, the following two columns automatically fill in the prices associated with that item.
Can this be done? It would make a huge decrease in the number of potential mistakes made when filling in these values manually.
Comments
-
you would want to use the lookup function
https://help.smartsheet.com/articles/775363-using-formulas#lookup
-
Thank you! Follup question:
Can the lookup function reference data in another sheet?
I cannot think of a way to put all the reference data on the same sheet we need the values to be populated on.
-
Just in case someone finds this thread, using Vlookup is an option and it indeed can reference other sheets. Though I strongly advise you to use the INDEX and MATCH function, it works the same as vlookup, is more flexible, but most importantly, it consumes A LOT LESS resources than the Vlookup does.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives