Forum Discussion

Joao_Silveira's avatar
Joao_Silveira
Copper Contributor
Nov 28, 2022
Solved

MS Project: Calculate risk with formula

Hello Community,   I want to use a custom field that shows me when the end date is less than today (past) or equal to today and the % Completed is less than 100%. I tried the following but it didn'...
Project
  • PlannersPlace's avatar
    PlannersPlace
    Nov 28, 2022

    Joao_Silveira 

     

    Use this formula IIf([Finish]<=[Current Date] And [% Complete]<100,"Yes","No") and add graphical indicators for "Yes" and "No"

     

     

     

     

     

PlannersPlace's avatar
PlannersPlace
Brass Contributor
Nov 28, 2022

Joao_Silveira 

 

Use this formula IIf([Finish]<=[Current Date] And [% Complete]<100,"Yes","No") and add graphical indicators for "Yes" and "No"

 

 

 

 

 

Joao_Silveira's avatar
Joao_Silveira
Copper Contributor
Nov 30, 2022
Many thanks, it worked perfectly!

Resources