Re: Can't Get a Field to Display the Results of My Formula
- From: John <mjensen@xxxxxxxxxxxx>
- Date: Thu, 24 May 2007 10:49:52 -0700
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
- References:
- Prev by Date: Re: Critical Path - Non direct tasks such as manage schedule, etc.
- Next by Date: Re: "budget" resource type in 2007
- Previous by thread: Re: Can't Get a Field to Display the Results of My Formula
- Next by thread: Re: Can't Get a Field to Display the Results of My Formula
- Index(es):
Relevant Pages
|
