update 1 sheet based on changing key
We are a manufacturing company that are managing lots of different parts in smartsheet serials etc.. which are not always stay the same.
we currently have 2 sheets on the same product which each of them is managed by a different person.
We are trying to update 1 sheet based on the key on the other sheet, but the key could be a bit different in both sheets and then smartsheet can't match between those id's. (as you can see in the images below it's 1 letter change).
we would love to find a solution that can update the sheet and show it in a report ( hyperlink won't work for us)
would love to hear any suggestions
Thank you all 🙏
Help Article Resources
Check out the Formula Handbook template!