Im working on a project tracking app demo.
I have two tables, one called Objectives which has an “objectives” column, a “goal” column which has a numeric value(i.e. “4” individual sales), and another column called “sum of all progress” which should track the total progress(sum) of all “project input” from the other table.
The other table I have called: “projects”, each project is related to an objective(enum). Each project has a column “input” that shows a numeric value which represents how much will this project adds to the total of the “goal” for that “objective”.
What I need to do is autopopulate the column “sum of all progress”, with the sum of all the projects “inputs” to the “goal” for that specific “objective”
Something like SUM.IF formula for Google Sheets.
I tried using SUM(SELECT) formula but it returns that it cannot compare Lists with texts.
Hope anyone can help. I hope I was clear enough, english is not my native language.