7 Replies Latest reply on Mar 24, 2016 1:02 PM by Jaspreet Narang

    Program Status based on Project Status

    Jaspreet Narang

      Hi everyone,

       

      I created a view which shows two programs and the projects underneath them. Every project has a RAG status associated with them.

      This is what I want to achieve -

      I want to create a field called "Program Status" where if any of the projects under the programs have a RAG status of "Critical" then the Program Status will be "Critical".

      If any of the projects do not have a RAG status of "Critical" but have a RAG status of "At Risk" then the Program Status will be "At Risk".

      If the above two conditions don't apply then the Program Status will be "On Track".

       

      I have attached the workbook also (Version 9.0).

       

      Any and all help will be appreciated.

       

      Thanks!

       

      Jesse