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

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 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
    ... Sara Miller wrote: ... 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: Optimal master and subproject organization
    ... Thanks both Jim and John for your insights! ... let's say for the System Engineering subproject. ... You can create as many custom views as may be needed using the custom ... subprojects that will be inserted into the master. ...
    (microsoft.public.project)
  • Re: Next & Previous buttons dont display data correctly in Access
    ... record counter) and custom buttons. ... NOTE - it is only display that is incorrect - the database remains ... > Exit Sub ...
    (microsoft.public.access.forms)
  • Re: Optimal master and subproject organization
    ... We use Dynamic Linking. ... You can create as many custom views as may be needed using the custom ... subprojects that will be inserted into the master. ... what we do is have one master and 8 inserted files that are ...
    (microsoft.public.project)
  • Re: DataRelations and DataGrids
    ... To be honest, while the default master-details display is kind of neat, I ... and update data in a flat display using DataGrid. ... > will be some redundant master table data in the result joined table. ... > There is a big updating synchronization issue about this way. ...
    (microsoft.public.dotnet.framework.windowsforms)