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