I am working with coordinating 10 different teams working on the same project. For those teams in Project I need the first one to start at a custom field ID of 1000, the second one to start at 2000, and so on to the last team starting at 10000. In order to do this I have created a formula using the formula:
IIf(([Outline Level]=2 And [ID]=2),1000,IIf(([ID]>2 And [ID]<103),([ID]-2)+1000,[ID]*0)) This sets the first team to custom field ID of 1000 (summary at line 2) and then all subsequent fields to 1001 to the end which ends at line 102. This formula works fine and does what I want. I simply expaned on it for the following teams changing the numbers accordingly. I did this with the first six teams with no problems using the below overall formula: IIf(([Outline Level]=2 And [ID]=2),1000,IIf(([ID]>2 And [ID]<103),([ID]-2)+1000,IIf(([Outline Level]=2 And [ID]=103),2000,IIf(([ID]>103 And [ID]<240),([ID]-103)+2000,IIf(([Outline Level]=2 And [ID]=240),3000,IIf(([ID]>240 And [ID]<353),([ID]-240)+3000,IIf(([Outline Level]=2 And [ID]=353),4000,IIf(([ID]>353 And [ID]<487),([ID]-353)+4000,IIf(([Outline Level]=2 And [ID]=487),5000,IIf(([ID]>487 And [ID]<534),([ID]-487)+5000,IIf(([Outline Level]=2 And [ID]=534),6000,IIf(([ID]>534 And [ID]<618),([ID]-534)+6000,[ID]*0)))))))))))) For the seventh team I replaced the "[ID]*0" with "IIf(([Outline Level]=2 And [ID]=618),7000,IIf(([ID]>618 And [ID]<828),([ID]-618)+7000,[ID]*0))", which by itself works fine, but when I added it with the overall formula I received this error message: "The formula contains a syntax error or contains a reference to an unrecognized field or function name." The overall formula causing the error is this: IIf(([Outline Level]=2 And [ID]=2),1000,IIf(([ID]>2 And [ID]<103),([ID]-2)+1000,IIf(([Outline Level]=2 And [ID]=103),2000,IIf(([ID]>103 And [ID]<240),([ID]-103)+2000,IIf(([Outline Level]=2 And [ID]=240),3000,IIf(([ID]>240 And [ID]<353),([ID]-240)+3000,IIf(([Outline Level]=2 And [ID]=353),4000,IIf(([ID]>353 And [ID]<487),([ID]-353)+4000,IIf(([Outline Level]=2 And [ID]=487),5000,IIf(([ID]>487 And [ID]<534),([ID]-487)+5000,IIf(([Outline Level]=2 And [ID]=534),6000,IIf(([ID]>534 And [ID]<618),([ID]-534)+6000,IIf(([Outline Level]=2 And [ID]=618),7000,IIf(([ID]>618 And [ID]<828),([ID]-618)+7000,[ID]*0)))))))))))))) When returning to the formula it identifies the greater than ">” between “[ID]>618” as the problem and once deleting that it moves on to the next character causing an issue until I am left with:
IIf(([Outline Level]=2 And [ID]=2),1000,IIf(([ID]>2 And [ID]<103),([ID]-2)+1000,IIf(([Outline Level]=2 And [ID]=103),2000,IIf(([ID]>103 And [ID]<240),([ID]-103)+2000,IIf(([Outline Level]=2 And [ID]=240),3000,IIf(([ID]>240 And [ID]<353),([ID]-240)+3000,IIf(([Outline Level]=2 And [ID]=353),4000,IIf(([ID]>353 And [ID]<487),([ID]-353)+4000,IIf(([Outline Level]=2 And [ID]=487),5000,IIf(([ID]>487 And [ID]<534),([ID]-487)+5000,IIf(([Outline Level]=2 And [ID]=534),6000,IIf(([ID]>534 And [ID]<618),([ID]-534)+6000,IIf(([Outline Level]=2 And [ID]=618),7000,IIf(([ID]),([ID])+7000,[ID]*0)))))))))))))) This admittedly works, but doesn?t display the numbers the way I need them to. I've tried with previous iterations of the formula and it always caps out at six teams. The only conclusion I can come to is that MS Project has a character limit on custom field formulas. Can anyone confirm this, or if that is incorrect lend assistance with what is incorrect in my formula? Thank you for your time and consideration with regards to this issue.