I’m a rose breeder, and I’m trying to create an app to track all my pollinations each day.
Currently, I have three tables: Roses, Crosses, and Daily Pollinations. I have each of these reference each other. When I create a new item/row in the Daily Pollinations table, it adds that to a list in the matching item in the Crosses table.
I would like to find a way to create a sum of all the pollinations for that specific cross. I’ve tried to figure out how to do this with different formulas, but I can’t figure out how to reference things correctly. Essentially, I need to take a specific column from the generated list for each item/row in Crosses and create a sum of that column inside the list.
Hopefully that makes sense. Thanks for any help!