Hello folks.
I am almost sure that someone might have asked the same thing, but I simply do not have time to look anymore as I have a lot of work to do.
Here's what I am doing:
I have one sheet where each line correspounds to a certain corporate objective (line 1 is "raise profits 10%", for example), and these objectives are composed by multiple goals(for instance, Objective 1 is composed by Goal1, Goal3 and Goal5) . These goals are listed in a diferent sheet. Each objective and each goal has a code (OB001, GL001, GL003,GL005).
For each objective, there's a cell which contains concatenated all the codes of the goals that compose this objective(GL001GL003GL005).
For each goal, there's a cell which contains it's status (0 for incomplete and 1 for complete).
What I want to do is make a formula that detects when all goals that compose an objective are complete, and then automatically set that particular objective as complete too.
The tricky thing is that the codes of the goals that compose the objective are all contained in a single cell, but I need to lookup each goal, return it's status then sum all of them and if the sum is equal to the number of goals, then the objective is complete.
I don't know if I am being clear, or if it would help to post an example sheet.
Bookmarks