none
Automatic Project Status RRS feed

  • Question

  • Hi ,

    How to setup project status automatically base on % complete ?

    We need to setup if %complete is equal to 50 then project status set to "incomplet" automatically.

    Thanks

    Iqbal

    Sunday, September 29, 2013 10:40 AM

Answers

  • Iqbal,

    You can create a Project Level Custom Text Field, with the following formula

    IIf([% Complete] = 100, "Complete", IIf([% Complete] = 50, "Incomplete", "In progress"))

    You can obviously change the "text" that appears.

    Remember, the project needs to be published before this field is updated in PWA.


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

    • Marked as answer by iqbalkmk Tuesday, October 1, 2013 8:44 AM
    Sunday, September 29, 2013 6:26 PM
    Moderator

All replies

  • Iqbal,

    You can create a Project Level Custom Text Field, with the following formula

    IIf([% Complete] = 100, "Complete", IIf([% Complete] = 50, "Incomplete", "In progress"))

    You can obviously change the "text" that appears.

    Remember, the project needs to be published before this field is updated in PWA.


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

    • Marked as answer by iqbalkmk Tuesday, October 1, 2013 8:44 AM
    Sunday, September 29, 2013 6:26 PM
    Moderator
  • Hi Prasanna ,

    Thank you .

    I done this formula

    Tuesday, October 1, 2013 8:05 AM