Solving for data issue when exporting data from external source.
I am trying to create a helper column that will help a colleague manage data that he needs to export from our inventory management system to evaluate in a team meeting. The issue is that he has currently been manually fixing a common data error where, occasionally, the name of an item is exported incorrectly. It always repeats the same exact issue and I was hoping I could solve for it to save him the extra work. Below are a list of the steps he is currently following to make the change.
- Search "Item Description" for the phrase "~Flower Lot - QA"
- Find another item description with a matching "Batch" and replace "~Flower Lot - QA" with the correct Item Description.
My thought was I could create a separate "Item Description" column that would use an IF statement to look for the incorrect item description, but I am not sure how I can pull the corrected one... index match is not an option since it might accidentally pull the wrong data...
I hope this all makes sense. I just want to make his job a bit easier. Below is a screenshot example of a correct vs incorrect item description. Hoping someone has a suggestion for a column for a different column that can fix the issue.
(Also forgive the example Item Description... I work in cannabis so our products have weird names.)
Help Article Resources
Check out the Formula Handbook template!