formulas in custom fields

5

57chevy

Hi, I'm trying to populate some custom date fields that I created in a
created table. I want the fields to be populated with a date that has been
inserted into the "Actual Finish" field of a particular task.
For example, I want the custom date1 field to equal the task16.Actual
Finish date and the custom date2 field to equal the task5.Actual Finish date.
Is this possible? I'm trying to create a report that makes sense to my
boss.
Thanks for your help.
 
D

Dale Howard [MVP]

57chevy --

You cannot write formulas in the manner you wish. You are asking the
software to calculate a value for one task using a value from another task,
which is not possible. Sorry.
 
5

57chevy

Thanks for the quick response Dale. I'm sure you also know if there is a way
to create a custom report that will allow me to list the "Tasks" vertically
down the page while listing the "Resources" which are associated with each
listed task horizonally across the page. I certainly appreciate your help.
 
D

Dale Howard [MVP]

57chevy --

You could create a custom task Table showing only the Task Name and
Resources column, apply that Table in the Task Sheet view, and then print
the view. You could also create a custom task Report based on the custom
Table you create. Hope this helps.
 
5

57chevy

After trying to follow your instructions (both suggestions), my result is a
list of tasks in one column and a list of the associated resources in another
column.
I'm trying to have one column listing all the tasks and then multple columns
(one column for each resource), but I don't believe that Project is going to
allow me to create such a view or table. Thank you much for your expertise.
 
D

Dale Howard [MVP]

57chevy --

Because of the multiple columns issue, you would probably need to write some
VBA code to send the data to Excel. Hope this helps.
 
5

57chevy

That is the conclusion to which I have come also. Thanks again. You have
helped save me a lot of time and effort in pursuing this farther. Merry
Christmas!
 
Top