none
Formula for RAG status RRS feed

  • Question

  • Hi,

    I'm trying to create a formula for an automated RAG status in MS Project 2010.

    I'd like the formula to show the below results.

    If %complete=100%, 1

    if the finish date=> baseline finish date up to 5 days , 2(Green)

    if the finish date>baseline finish date between 6-9 days,3 (amber)

    if finish date>baseline date by more than 10 days , 4(red)

    Please could anyone help me with the formula?

    Thanks

    Thursday, May 29, 2014 6:21 PM

All replies

  • You could directly show the text, instead of a number. Just use this formula in a "text" field.

    IIf([% Complete]=100,"Complete",IIf([Finish]-[Baseline Finish]>10,"Red",IIf([Finish]-[Baseline Finish]>=6,"Amber","Green")))

    If you definitely want a number, just replace the text with number and use it in a number field.

    Also, you might want to include a condition for where there is no baseline.


    Prasanna Adavi,PMP,MCTS,MCITP,MCT http://thinkepm.blogspot.com

    Thursday, May 29, 2014 6:54 PM
    Moderator