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.
How do I automate and validate data from one column to another
For example, have a list of cost centres in one column using a drop down list, now I want the managers name for that cost centre to populate in next column.
In excel i would just use a lookup or match/index to validate and populate.
Cannot work out how to do it in smartsheet.