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

Wayne Crowley
edited 12/09/19 in Archived 2016 Posts

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.


  • JamesR
    JamesR ✭✭✭✭✭✭


    Smartsheet has all three of these functions and they work very much the same way as in Excel.


    Have a look in the Help and you will see the Syntax and examples.


    Rule of thumb - On your sheet you need a table that has Costcenters and thier managers listed to use as your lookup table/column.  Note if you want your Managers name to be a contact list item then the formulae will only bring back the text element of the Contact Name and not the email address.



This discussion has been closed.