Hi,
I am working on a one file, where project status has to be maintained.
Status are Delayed, Risk of Delayed and on track.
File has 2 tabs, first tab is the place where we want to show value from second tab.it is kind of a summary tab
Second tab where we have details about any project.
Point to note- one project is divided into different phases.one project can have N number of phases.
One phase status can be different from others.
in 1st tab we have this one project name only. Formula need to read each phase status from 2nd tab and then show the status on first tab as per importance.
Importance is as follows:-
I am working on a one file, where project status has to be maintained.
Status are Delayed, Risk of Delayed and on track.
File has 2 tabs, first tab is the place where we want to show value from second tab.it is kind of a summary tab
Second tab where we have details about any project.
Point to note- one project is divided into different phases.one project can have N number of phases.
One phase status can be different from others.
in 1st tab we have this one project name only. Formula need to read each phase status from 2nd tab and then show the status on first tab as per importance.
Importance is as follows:-
- If the status shows DELAY on any of the phases for that project, the formula for tab1 shows “DELAY”; if not, then:
- If the status shows RISK OF DELAY on any of the phases for that project, the formula for tab1 shows “RISK OF DELAY”: if not, then:
- Formula shows “ON TRACK