Hi there,
Is there a way I can grab data from one table cell associated to a product and then drop it to another table and place it in there and have a formula to sum historic registers from the other table?
This is what I need in images
First, I have this table called "Facturas" which substracts" Cantidad Solicitada" by "Cantidad Entregada", then the result is saved in "Por Entregar", then this total needs to go to another table called "Inventario" and saves its data to "Acumulado por entregar ", in here besides getting data from "Cantidad Entregada" it also has to sumarize each time a value is submitted in "Cantidad Entregada" "Cantidad Entregada"t means products pending to be delivered, so that user always know what quantity and specific products are pending to be delivered, how can I do that?
Hi Alyssa, trying to do the exact same thing here, but when applying only the filter it doesnt find anything. My difference is that one of the condition elements is a cell from same row which is a picklist:
For your filter expression, could you try something like this? =FILTER(Precios_Materiales,"Precios_Materiales[Material]=[Material][insert column name here]")
Replace the text of insert column name here with the actual column name from the table that this table's Material column (C) is referencing.
@Bocu-405b, I wanted to follow up with a specific example here as I believe I understand what you are after. The approach is slightly different than my first response because this uses our =FINDROW function to retrieve the specific price of the material defined in your column B.
With this setup, to determine the price of the material in the Relacional_Tratamiento_Material table, you can use this expression: =FINDROW(Precios_Materiales,"Precios_Materiales[Material]=[Material][Name]")[Price]