Kashif Nizam Qureshi

Custom Field Project Status Indicator

2 Comments

 

Name: Project Status Indicator

Type: Number

 

Formula: IIf((ProjDateDiff([Baseline Start], [Start], [Project Calendar]) / 420) <= 0, “1”, IIf((ProjDateDiff([Baseline Start], [Start], [Project Calendar]) / 420) > 0 And (ProjDateDiff([Baseline Start], [Start], [Project Calendar]) / 420) < 5, “2”, “3”))

indicator

Advertisements

2 thoughts on “Custom Field Project Status Indicator

  1. Hi Kashif,

    I have used this formula with all instructions, and I have removed [Project Calendar] because we don’t use it, it gives me error that your formula contains error. Can you guide me that?

    Thanks,

    • Hi Sohail,

      I’m sorry couldn’t get back earlier as I was on vacation. Can you show me your formula? Secondly, what is the type of your field? Have you baselined your project? There could be many reason for which you are getting an error. Tell me some details and hopefully we’ll sort it out.

      Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s