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

customize fields

ResolvedVersion 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:

Compare Work and Duration

Duration is the timescale within which a task is done; Work is the specific time element used. For example, 3 days work in a duration of 2 weeks. To compare, add the Work field into the Entry table by right clicking a column heading to Add Field.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.