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

edited 12/09/19 in Archived 2017 Posts

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. 



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. 


This discussion has been closed.