One to Many Report

I have created two smartsheets

1.      KeyHolderList

2.      KeysIssuedList

The KeyHolderList contains the following columns:

·        EmployeeID (primary)

·        FirstName

·        LastName

The KeysIssuedList contains the following columns:

·        EmployeeID (primary)

·        KeyName

·        DateIssued

·        DateReturned

The KeyHolderList will only ever have just one row per employee.

The KeysIssuedList will potentially have numerous rows per employee.

The data from the two sheets are intended to be tied together through the primary field (EmployeeID)

I’d like to be able to run a report that displays a list all of the employees from the KeyHolderList along with the detail data from the KeysIssuedList. 

Is this possible in Smartsheet? 

Thanks in advance for any help you can give me.

Best Answer