joaquinfreije
New member
Hi there! I'm Joaquín from Argentina. I own a hamburger restaurant, and we use google sheets to send information in real time from the order taker to the kitchen. As you will see below, there are different boxes where we put essential data. To cut to the chase, there are two boxes that are important for the problem at hand. The box where we put the ordered burgers in code form (for example "baconx1, clasica, lifex3") and the "quantity of beef patties" box. I have been looking for days how to do the following, but I have not found a solution: I need the "quantity of meat medallions" box to automatically detect the codes of the hamburgers and transform them into numbers and add them together. The problem is that I don't know what formula to use, it's the only information I need. At first I thought I could use the if function but it cannot detect and sum different values within the same cell.
In case it was not clear, I would need to assign a number to each hamburger code so that in the mentioned cell it automatically shows the necessary patties we need to cook for the block.
I leave at the end an editable link of the sheets in case it is useful for you to see it.
Thank you very much for your help, any advice or comment would be very useful. Cheers!
Hamburguer sheets
In case it was not clear, I would need to assign a number to each hamburger code so that in the mentioned cell it automatically shows the necessary patties we need to cook for the block.
I leave at the end an editable link of the sheets in case it is useful for you to see it.
Thank you very much for your help, any advice or comment would be very useful. Cheers!
Hamburguer sheets