Hi,
I've been trying to solution a use case, and I'm curious if we can do it in Smartsheet. The use case is ordering materials for individual restaurants based on specific criteria. I was thinking that I can set up one sheet with the restaurant specific information (name, address, city, other required criteria), and a second sheet with the materials that are required for the order. But now I need to create a report (?) where you merge the restaurant information with the material list to create a list of materials for each restaurant based on the information in both sheets. So, for example, the materials list might say restaurants in Alberta need 4 chairs and restaurants in BC need 3 chairs, so the final output would have 4 chairs assigned to all restaurants in AB and 3 to restaurants in BC. I would need both a list of the individual restaurants with the orders assigned to them, as well as a rollup of how many chairs need to be ordered to send to the manufacture. I should add that this would be a stand alone workspace, and not tied to any other data that we have in our Smartsheet solution.
I've tried reporting, and it doesn't seem like I can easily get the output I want. I'm not sure if control centre would work? Are there any other Smartsheet apps that might assist? Or does this sound like a use case that's better solutioned outside of Smartsheet? Thank you!
