customize fields

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Customize fields

Customize fields

resolvedResolved · Low Priority · Version 2003

Simona has attended:
Project Intro Intermediate course
Project Advanced course

Customize fields

Hi, I want to enter a formula to change duration to 0 days when my text field is selected to "yes". But I can't enter formula to duration field. I chose Duration1 but project doesn't update Gant chart from Duration1 field, is any way I can work around this. Formula I used in Duration1 is =IIf([Text3]="Yes",0,[Duration]).

RE: Customize fields

Hi Simona

Thanks for your question. This sounds like it would be better resolved using a macro. You can find example macros in Project under Tools > Macro > Macros. Macros are programming code that automate processes in the management of your Project. Because macros are powerful and potentialy could damage your Project we don't normally provide code via the forum. If this is something that you would like developing or testing by all means let us know and we can propose a way forward. This may be billable work.

Kind regards,

Andrew


 

MS Project tip:

Avoid Accidental Constraints

The initial default table is the Entry table. Enter a task name and duration, but do not enter start or finish dates. Form the plan using links, predecessors. Typing dates introduces constraints. To remove these constraints, double click on a task, and on the Advanced page of Task Information set the constraint back to As Soon As Possible (all other options are there too.)

View all MS Project hints and tips


Server loaded in 0.08 secs.