How best to automate moving data from one sheet to another based on certain criteria?

David Brandt
David Brandt ✭✭✭✭
edited 01/10/23 in Formulas and Functions

I am trying to reference a list of people in Smartsheet A and pull associated data based on that list into another Smartsheet B. I have people listed this way: Column1: Last name, Column2: First name, Column3: email address. Also in Smartsheet A (Column6) there is an alpha numeric designation associated with each person that puts them into a group (T1, T1+, T2, T2+, T3, T3+ T4). In Smartsheet B, Column9 includes a dropdown menu of each person (last name, first name - business affiliation).

Is there a way to add an additional, let's say, Column10 to Smartsheet B and have it auto-populated with the persons' group number (based on Smartsheet A data) when that person is selected/recognized in Column9?

Thanks in advance for any ideas on the best solution to accomplish this.

Many thanks,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!