data validation in Microsoft Project

Question

Hey

I hope you all doing great!

I am using Project Pro 2016 and I want you to guide me to find a way to validate my data in my resources. I want to make a rule in Resources Text field to write phone numbers with 10 numbers longer only, not less and not more.

so if I wrote 9 numbers, it won't accept it and I need to repeat it, or it turns empty or any other ideas you can provide me.

Thank you.

Answer 1

CRManagement,

Okay, which Resource Text field, there are 30 of them?

Assuming you are using Resource Text1 field for the resource's phone number, this formula in the Resource Text2 field will indicate if you entered 10 digits for the phone number. Note that is you include delimiters (e.g. dashes, slashes, etc.) in the entry, the test value needs to change accordingly.

Text2=IIf([Text1]="","no entry",IIf(len([Text1])<>10,"error","OK"))

In order to do a direct check of your entry as you type it in, an Event triggered VBA macro is required and that my friend is a couple orders of magnitude more complex (i.e. you don't want to mess with it).

John

Answer 2

Dear John,

Yes, I will write the phone number in Resource text field

Thank you

Answer 3

CRManagement,

Where exactly are you entering the phone number for the resources (e.g. Resource Text field, Resource Notes field, etc.)?

You say you are using Project Pro plus. What exactly is the "plus"?

John

Answer 4

Hello

Thank you for your fast reply.

unfortunately, I have project professional 2016.. and I don't think the link will guide me to solve the problem I have.

Best regards

Answer 5

Hi,

Welcome in Microsoft community.

Given the problem description, we sincerely request some time to set up environment to investigate this problem further and get back you as soon as possible.

As we are investigating this, we find a reference article that may have such feature related to data validation. Resolve validation errors - TFS | MicrosoftDocs. It mentions that “When you publish an enterprise project plan that is mapped to a project, the Team Foundation add-in for Microsoft Project Professional performs several data validation checks.”

Meanwhile, we want to confirm:

• Whether you have Enterprise Project license,

Appreciate your cooperation.

Regards,

Christophe