How to Update/Merge rows when another row is created with the same name?
I am creating a design matrix of sorts to track employee skill levels and allow for employees to reach out to others with higher skill level for mentorship.
It is intended that this sheet would be updated whenever an employee felt that there skill level had been enhanced. Employees have access to a form but not the sheet so whenever they update their skills the sheet does not auto-update and merge the rows. I am wondering if there is a way to do this, if Smartsheet can detect that there is duplicates of the same name and then update the old row with the new values, whilst keeping the old values which are not updated.
For example Aaron has updated his skills twice since the original (blue) I would like the new values to be moved into the original overriding the old values, but only for the skills that have new values, and ignore the blanks.
Any help on this is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!