Can anyone help me find a formula to get column 3 using only one table
Hi @Adalberto_Santos_de_los_Santos - can you tell me more about Column 3. Is what you want to populate in there based on Column 1 and 2 and if so what is the pattern?
I’m trying to control and manage a Sheep Production Inventory.
Maybe this will help. I’m trying to find the brothers of each lamb
That makes so much more sense. Try this formula - thisTable.Filter(thisRow.[Column 2]=[Column 2])
https://cl.ly/0l2x3G3Y3N0o/Image%202018-07-24%20at%202.39.23%20PM.png
1 Like
Excelent! It worked perfectly.
Thanks