98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Customize fields
Customize fields
Resolved · 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Avoid Accidental ConstraintsThe 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.) |