Field Formula?

**devbro** · 18-12-2006

Hi

I have created a drop-down menu using a custom text field and wish to enter a date into Baseline Finish based on the users selection. For example; if the user selects J350 from the drop-down, it enters 1/20/07 in the Baseline Finish. There are roughly 20 possibilities the user could select so it would be nice if I could centrally store a simple matrix or look-up table that Project could pull from.

As a side note, the drop-down selections represent the assembly cost center and the Baseline Finish is the assembly load date. The reason the load date is the Baseline Finish is because I’m scheduling from the Project end date backward to schedule all events necessary to design and fabricate parts for assembly. The load dates change periodically and I need a way to ensure consistency and accuracy across schedules.

VB, Macro, Formula….????????

**1kshana** · 19-12-2006

I think you need manually set all baseline fields or using VBA on other fields because as far as I know formula can be live in custom fields only.

**devbro** · 19-12-2006

Thanks 1kshana,

How would I do this with VBA?

**Beckinsale** · 19-12-2006

First of all you will need a proper design unless which it is very difficult to do. Also remember that as you are scheduling just in time hope you are aware that all tasks will be critical doing so hence if any delay made in any one task will result in delay of the final finish date. So you will need to find out a method to import dates and storing them properly and analyzing them based on the value in the Custom text field.