I have a situation where a form request for products populates a sheet but the products requested may not be available in that market so the request is an invalid one. It would be great if, after form submission, we could compare the new row (request) against a matrix sheet of available products. Has anyone done that before with a Smartsheet solution?
Here is a simple example of my situation:
An Arizona customer is requesting Product B and Product C but, according to our availability matrix, only Product A and B are available in AZ. I'd like to compare the customer request with the available products in that state to notify the customer that their request could not be completed. Is there a way to compare a request against a data matrix of available products?
Customer Requests
Product Availability Matrix
This is a simplified example as the actual number of states, territories, and countries could be in the hundreds at some point and the products in the availability matrix could grow to a hundred as well.