Check a box when a match for a value is found on another sheet
I have a sheet called Parts Database used to track parts as they go through a production process. Screenshot below. Currently, workers check off the status of each part as they go, which is not practical with the quantity of parts.
Ideally, I want them to be able to fill in a response form at the end of the day listing out all of the parts that have completed the "Bend" step that day, separated by commas. I want the Parts Database [Bend] column to check a box when the Part # at its row is entered onto the Response Form. Note that there are a mix of positive, negative, and regular Part #s, so the search has to be able to distinguish between these options.
Any ideas how I could accomplish this?
Help Article Resources
Check out the Formula Handbook template!