Multiple contact list in a column

Tom T
Tom T
edited 12/09/19 in Smartsheet Basics


Is there a way to create multiple sets of group contacts or drop down lists in a single column so that only a specified set of contacts or individuals can be selected based on what information is selected in a drop down list from an adjacent column?  For example, if I have 100 people in a contact list but, they are associated with three different physical locations. 50 to Building A, 25 to Building B and 25 to Building C.  I would like to select Building A in one column and only have the ability to select the 50 individuals associated with this building in a separate column instead of having all 100 individuals show up in the list.