Hello Smartsheet's community!
I am back with another question. I have a database that holds the tracking of employee trainings. The training structure is in tiers and after each completed tier they fill out a form. The raw data from this forms looks like this:
Depending on an employee's level they will have a differing amount of rows entered.
Example: L1 employees will have 2 rows filling in all of the green columns.
I am looking to create a spreadsheet that combines/concatenates all of this data into one row based off of the "Alias" value.
Example: "Test 1" employee only has 1 row filling all green columns with "trained".
End result to look like this:
The reason for needing this is I am trying to create a dashboard that shows each employees training completion and if/what training's they are missing.
As always appreciate the help!
Thanks :)