Re: Can't Get a Field to Display the Results of My Formula

Tech-Archive recommends: Speed Up your PC by fixing your registry

In article <8A932B9B-E0AC-46A0-8C16-F7423FF72083@xxxxxxxxxxxxx>,
Sara Miller <SaraMiller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Success! Not only was I able to create the formula in the individual file,
but I also customized it to display a graphical indicator (red, yellow, green
dots) in the Text field. Once I created this in the individual file it is
also displayed in the Master.

Thanks so much for your help John!
Sara

Sara,
You're welcome although I see you now have a new problem (your new post
today).

John

"Sara Miller" wrote:

Ahah! I think you've got itâ??I was trying this in an inserted sub-project. I
will test this out as soon as I get back in the office on Tuesday.
Thanks!
Sara

"John" wrote:

In article <9CAA3CC6-BCAA-4F72-8CAC-AD38823AAF37@xxxxxxxxxxxxx>,
Sara Miller <SaraMiller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thanks for the reply John. Actually I did try it in a Text field with
the
same result.
Sara

Sara,
So are telling me that you put your formula in a spare text field and it
did NOT work there either? That's strange because it works fine for me.
I would check your data very carefully to make sure it is valid. Also,
if you are trying to do this on a master file with inserted projects,
the formula will only apply to tasks that are actually part of the
master. For a formula to work on tasks in a subproject file that is
inserted into a master, the formula must reside in the subproject file
itself.

John
Project MVP

"John" wrote:

In article <1996494A-309A-48E5-9429-B0201D0694CE@xxxxxxxxxxxxx>,
Sara Miller <SaraMiller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have checked previous postings & gotten some great tips but I
must be
missing something 'cause I just can't get this to work!

What I want to end up with is a field that displays the difference
in
days
between the date in the Finish field and the date in a custom field
called
Required (Date1). I've customized the Date2 field to have this
formula:
DateDiff("d",[Finish],[Date1]). The formula is accepted but there
is
nothing
displayed in the Date2 field. Any pointers much appreciated!

Sara

Sara,
There is nothing wrong with the formula itself so the formula will be
"accepted". However, you are trying to put non-date information into
a
spare date field and that won't work. Try putting your formula in a
spare text field.

John
Project MVP


.

Relevant Pages

  • Re: Cant Get a Field to Display the Results of My Formula
    ... Not only was I able to create the formula in the individual file, ... but I also customized it to display a graphical indicator (red, yellow, green ... also displayed in the Master. ... between the date in the Finish field and the date in a custom field ...
    (microsoft.public.project)
  • Re: That circular reference thing again...
    ... Sara Miller wrote: ... another purpose but it also helps me track down circular relationships ... in master files, however, it is not freeware. ... be that someone attempted to link summary lines of subprojects that are ...
    (microsoft.public.project)