So my question is complex and I am doubting it can be done.
I have a training matrix with 'Item' (Unique for each item) as rows and People as Columns.
In the Person column, the date is entered when the person is trained to an Item.
What I want to do now is to set up a training record smartsheet where the item and date trained is the row and the Trainees are the columns. The trainee columns are contact cells and will contain email addresses of the trainees and be populated using a Smarthsheet form.
So I wanted to take the Date that the item was trained for all trainees and automatically get it entered in the training matrix.
This sounds complex and I feel based on the fact that there are not enough common factors across the sheets it may not be possible.
Currently dates of training completed are manually entered into the training matrix by the trainees and there is no digital training record.
Future state for me is to capture training on a Smartsheet form.
The objective would be to then automatically take the date that the trainee was trained and enter that date in the cell of the common and unique 'Item' and the column corresponding with trainee.
Currently trainee columns are named 'John Doe' for example.
In the training record the columns will be 'Trainee 1' , 'Trainee 2' etc and the cell will contain the email address of the trainee. So only common link (from a look up perspective) is the 'Item'. This would be common in both sheets.
This is complex and maybe can be simplified by renaming columns but the sheets serve 2 different use cases so I am not sure if they can effectively cross link how I want.
Referring to the image, I want the info from 'Date' column in the training record (ie 19/06/25) to automatically get put into the 'AJ Barry' column for the item 'OP0012'. And overwrite the existing date of 17/02/25 (currently entered manually)
