Field Formula?

[devbro]

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….????????

Hi,

Formulae can only live in custom fields so all other fields, including all
baseline fields need to be set manually or by VBA.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com


"devbro" <devbro.2j0xbe@DoNotSpam.com> wrote in message
news:devbro.2j0xbe@DoNotSpam.com...
>
> 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..????????
>
>
> --
> devbro
> ------------------------------------------------------------------------
> devbro's Profile: http://forums.techarena.in/members/20287.htm
> View this thread: Field Formula?
>
> http://forums.techarena.in
>

[devbro]

Thanks Rod,

How would I do this with VBA?

Without a proper design, teh answer is can't know! You are scheduling Just
in time so be aware that this makes all tasks critical, so a delay in one
task causes a delay in teh final finish date - Risky!

You need a way of importing the dates and storing them, then looking them up
based on the value in the Custom text field. There are a number of ways to
do this, the best, easiest and quickest way will depend on what information
you have, where it comes from, what format and more.



--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com


"devbro" <devbro.2j12vc@DoNotSpam.com> wrote in message
news:devbro.2j12vc@DoNotSpam.com...
>
> Thanks Rod,
>
> How would I do this with VBA?
>
>
> --
> devbro
> ------------------------------------------------------------------------
> devbro's Profile: http://forums.techarena.in/members/20287.htm
> View this thread: Field Formula?
>
> http://forums.techarena.in
>

Devbro,
You have already created the basis for what you need.

Customize Finish10 to be: Choose([Number20],"1/20/07","2/20/07","3/20/07"),
entering the correct 20 dates.
So that you don't lose what you already have working, copy the values from
your text field (J350, etc.) and paste them into the description field in
another custom field, say number20. The values for Number20 should correspond
to the sequence that you enter dates into the Finish10 field. For example,
Row 1 has a value of 1 and a description of J350. When the user uses the drop
down, 1 - J350 is displayed. When they select J350, only the 1 is retained.
Use this with caution because you can have multiple descriptions equal a
value of 1 and multiple values equal the same description.

"Rod Gill" wrote:

> Without a proper design, teh answer is can't know! You are scheduling Just
> in time so be aware that this makes all tasks critical, so a delay in one
> task causes a delay in teh final finish date - Risky!
>
> You need a way of importing the dates and storing them, then looking them up
> based on the value in the Custom text field. There are a number of ways to
> do this, the best, easiest and quickest way will depend on what information
> you have, where it comes from, what format and more.
>
>
>
> --
>
> Rod Gill
> Project MVP
>
> NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
>
>
> "devbro" <devbro.2j12vc@DoNotSpam.com> wrote in message
> news:devbro.2j12vc@DoNotSpam.com...
> >
> > Thanks Rod,
> >
> > How would I do this with VBA?
> >
> >
> > --
> > devbro
> > ------------------------------------------------------------------------
> > devbro's Profile: http://forums.techarena.in/members/20287.htm
> > View this thread: Field Formula?
> >
> > http://forums.techarena.in
> >
>
>
>

[devbro]

Rod,
......slick......!

Thanks