How do I automate and validate data from one column to another

Wayne Crowley

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

Wayne,

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.

 

James