S
Steve Scott
I have been using a custom formula for about two years now on upto 200 plans.
It takes the text that is recorded in the Title field of the Summary tab in
the File/Properties of the plan and uses it to populate the Text 8 field as
follows:-
Text 8 = [Title]
Occasionally and probably only ever reported on a handful of project files,
the text 8 data is not being refreshed when the data in the Summary tab in
the File/Properties of the plan is changed. One way of resolving it is to
blank out the text in the Summary tab in the File/Properties of the plan and
then to tye the value back into the Summary tab in the File/Properties of the
plan which then successfully refreshes the value shown in Text 8. Where
this becomes more bizarre is when the only way to get the text showing in
Text 8 is to preceed the data in teh Summary tab in the File/Properties of
the plan with a space! This is not satisfactory at all for PMs as it does
not have any logical explanation but also does not allow me to search for
that text8 value across multiple plans unless I remember to search for
contains the text instead of equals ie taking into account teh possible
spaces. Why is project not properly calculating as directed by teh formula
in these instances???
It takes the text that is recorded in the Title field of the Summary tab in
the File/Properties of the plan and uses it to populate the Text 8 field as
follows:-
Text 8 = [Title]
Occasionally and probably only ever reported on a handful of project files,
the text 8 data is not being refreshed when the data in the Summary tab in
the File/Properties of the plan is changed. One way of resolving it is to
blank out the text in the Summary tab in the File/Properties of the plan and
then to tye the value back into the Summary tab in the File/Properties of the
plan which then successfully refreshes the value shown in Text 8. Where
this becomes more bizarre is when the only way to get the text showing in
Text 8 is to preceed the data in teh Summary tab in the File/Properties of
the plan with a space! This is not satisfactory at all for PMs as it does
not have any logical explanation but also does not allow me to search for
that text8 value across multiple plans unless I remember to search for
contains the text instead of equals ie taking into account teh possible
spaces. Why is project not properly calculating as directed by teh formula
in these instances???