I need help with an expression.
I have a new table with a row referencing [Plant ID] which is the key in two of my other tables.
I would like to create a formula that adds up the value of Design Reorganization Table[# of plants] when the [Plant ID] in that table is equal to the value of the [Plant ID] in the new form I am creating (which the user selects in a drop down menu that is a ref to a different table).
Design Reorganization Table has many rows with the same Plant ID, so I am trying to get it to add them all up (Ie. SUM)
It seems this is easy if the Plant ID were to stay the same.
Then I could specify “Carrots Yaya”.
But I would like the Plant ID value to be able to change, depending on what the user selects.
I don’t think Filter or Lookup are going to work here because they need that specific text, not a ref to the value of a Column.
But maybe I’m wrong?
Thanks for the help!