Project Owner field

[Robert]

Hi,

Is it possible to refer to the Project Owner field in a formula (Project
Entity custom field)?
How?
Thanks

 

[Dale Howard [MVP]]

Robert --

I just ran a quick experiment. To my surprise, I could not write a Project
field with a formula that references the Project Owner field. I used the
following formulas, both of which generated an error:

[Owner]
[Project Owner]

So, unless this field carries some other name that I do not know about, I
guess the answer is no, you cannot create a formula that references the
Owner field. But perhaps someone else has an idea for you.

 

[Andrew Lavinsky]

Just thinking of a couple of options that I would try:

I don't have a copy of Project Server open in front of me, but the task level
field will reference [Author], which is a Project File Property. Not sure
if that can be surfaced into an Enterprise Project level field, but it's
possible. You might try that in an Enterprise field to see what happens.
Author defaults to the person who created the project - so it's almost the
Owner field, depending on how much you change things after the project is
created.

Your other option would be to somehow create an Enterprise field that pulls
the Status Manager(s) from the project and surfaces that at the project level.
According to most of the security structure, anyone with Status Manager
rights would often have the same permissions as owner.

I can play with that next time I fire up a VPC.

What kind of formula do you wish to develop, out of curiousity?

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Robert --

I just ran a quick experiment. To my surprise, I could not write a
Project field with a formula that references the Project Owner field.
I used the following formulas, both of which generated an error:

[Owner]
[Project Owner]
So, unless this field carries some other name that I do not know
about, I guess the answer is no, you cannot create a formula that
references the Owner field. But perhaps someone else has an idea for
you.

Hi,

Is it possible to refer to the Project Owner field in a formula
(Project
Entity custom field)?
How?
Thank

 

[.jussi]

Robert,

There are two caveats in using the author field. First, if you are creating
your project from an enterprise template, the project author will be the
template author. Second, if you switch project managers, the author will not
be updated.

That said, if you give a bit more explanation of what you are trying to do,
maybe someone will have a workaround for you.

Hope that helps,
- Jussi

--
http://finepm.blogspot.com/

Just thinking of a couple of options that I would try:

I don't have a copy of Project Server open in front of me, but the task level
field will reference [Author], which is a Project File Property. Not sure
if that can be surfaced into an Enterprise Project level field, but it's
possible. You might try that in an Enterprise field to see what happens.
Author defaults to the person who created the project - so it's almost the
Owner field, depending on how much you change things after the project is
created.

Your other option would be to somehow create an Enterprise field that pulls
the Status Manager(s) from the project and surfaces that at the project level.
According to most of the security structure, anyone with Status Manager
rights would often have the same permissions as owner.

I can play with that next time I fire up a VPC.

What kind of formula do you wish to develop, out of curiousity?

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Robert --

I just ran a quick experiment. To my surprise, I could not write a
Project field with a formula that references the Project Owner field.
I used the following formulas, both of which generated an error:

[Owner]
[Project Owner]
So, unless this field carries some other name that I do not know
about, I guess the answer is no, you cannot create a formula that
references the Owner field. But perhaps someone else has an idea for
you.

Hi,

Is it possible to refer to the Project Owner field in a formula
(Project
Entity custom field)?
How?
Thanks

.

 

[Robert]

Thanks everybody,

What I would like to do is to make a grouping by Owner in the File|Open
dialog of Project Pro 2007.
But I'm afraid we can do that only on custom fields with a lookup table...
Thanks again for your help

Robert,

There are two caveats in using the author field. First, if you are
creating
your project from an enterprise template, the project author will be the
template author. Second, if you switch project managers, the author will
not
be updated.

That said, if you give a bit more explanation of what you are trying to
do,
maybe someone will have a workaround for you.

Hope that helps,
- Jussi

--
http://finepm.blogspot.com/

Just thinking of a couple of options that I would try:

I don't have a copy of Project Server open in front of me, but the task
level
field will reference [Author], which is a Project File Property. Not
sure
if that can be surfaced into an Enterprise Project level field, but it's
possible. You might try that in an Enterprise field to see what happens.
Author defaults to the person who created the project - so it's almost
the
Owner field, depending on how much you change things after the project is
created.

Your other option would be to somehow create an Enterprise field that
pulls
the Status Manager(s) from the project and surfaces that at the project
level.
According to most of the security structure, anyone with Status Manager
rights would often have the same permissions as owner.

I can play with that next time I fire up a VPC.

What kind of formula do you wish to develop, out of curiousity?

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Robert --

I just ran a quick experiment. To my surprise, I could not write a
Project field with a formula that references the Project Owner field.
I used the following formulas, both of which generated an error:

[Owner]
[Project Owner]
So, unless this field carries some other name that I do not know
about, I guess the answer is no, you cannot create a formula that
references the Owner field. But perhaps someone else has an idea for
you.


Hi,

Is it possible to refer to the Project Owner field in a formula
(Project
Entity custom field)?
How?
Thanks

.

 

[Ben Howard [MVP]]

Hi Robert,

I've simply done this by creating an Enterprise Project Text field called PM
associated with a lookup table. This is simple and effective...
--
Regards, Ben.

Thanks everybody,

What I would like to do is to make a grouping by Owner in the File|Open
dialog of Project Pro 2007.
But I'm afraid we can do that only on custom fields with a lookup table...
Thanks again for your help

Robert,

There are two caveats in using the author field. First, if you are
creating
your project from an enterprise template, the project author will be the
template author. Second, if you switch project managers, the author will
not
be updated.

That said, if you give a bit more explanation of what you are trying to
do,
maybe someone will have a workaround for you.

Hope that helps,
- Jussi

--
http://finepm.blogspot.com/

Just thinking of a couple of options that I would try:

I don't have a copy of Project Server open in front of me, but the task
level
field will reference [Author], which is a Project File Property. Not
sure
if that can be surfaced into an Enterprise Project level field, but it's
possible. You might try that in an Enterprise field to see what happens.
Author defaults to the person who created the project - so it's almost
the
Owner field, depending on how much you change things after the project is
created.

Your other option would be to somehow create an Enterprise field that
pulls
the Status Manager(s) from the project and surfaces that at the project
level.
According to most of the security structure, anyone with Status Manager
rights would often have the same permissions as owner.

I can play with that next time I fire up a VPC.

What kind of formula do you wish to develop, out of curiousity?

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Robert --

I just ran a quick experiment. To my surprise, I could not write a
Project field with a formula that references the Project Owner field.
I used the following formulas, both of which generated an error:

[Owner]
[Project Owner]
So, unless this field carries some other name that I do not know
about, I guess the answer is no, you cannot create a formula that
references the Owner field. But perhaps someone else has an idea for
you.


Hi,

Is it possible to refer to the Project Owner field in a formula
(Project
Entity custom field)?
How?
Thanks


.

.

 

[Andrew Lavinsky]

....not to detract from Ben's suggestion, but there's already a free text
field which is called Project Manager and pulls from the File Properties

Manager field. Then you'd have two fields, one called PM and Project Manager

- which seems a bit inelegant.

Robert - have you tried grouping by the Project Manager field? The only
issue is that it's free text, but hopefully the PMs should be able to enter
their own name in a relatively standard fashion.

(That being said, I've been known to do the same thing as Ben suggested.)

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi Robert,

I've simply done this by creating an Enterprise Project Text field
called PM associated with a lookup table. This is simple and
effective...

Thanks everybody,

What I would like to do is to make a grouping by Owner in the
File|Open
dialog of Project Pro 2007.
But I'm afraid we can do that only on custom fields with a lookup
table...
Thanks again for your help

Robert,

There are two caveats in using the author field. First, if you are
creating
your project from an enterprise template, the project author will be
the
template author. Second, if you switch project managers, the author
will
not
be updated.
That said, if you give a bit more explanation of what you are trying
to
do,
maybe someone will have a workaround for you.
Hope that helps,
- Jussi
-- http://finepm.blogspot.com/

:

Just thinking of a couple of options that I would try:

I don't have a copy of Project Server open in front of me, but the
task
level
field will reference [Author], which is a Project File Property.
Not
sure
if that can be surfaced into an Enterprise Project level field, but
it's
possible. You might try that in an Enterprise field to see what
happens.
Author defaults to the person who created the project - so it's
almost
the
Owner field, depending on how much you change things after the
project is
created.
Your other option would be to somehow create an Enterprise field
that
pulls
the Status Manager(s) from the project and surfaces that at the
project
level.
According to most of the security structure, anyone with Status
Manager
rights would often have the same permissions as owner.
I can play with that next time I fire up a VPC.

What kind of formula do you wish to develop, out of curiousity?

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
Robert --

I just ran a quick experiment. To my surprise, I could not write
a Project field with a formula that references the Project Owner
field. I used the following formulas, both of which generated an
error:

[Owner]
[Project Owner]
So, unless this field carries some other name that I do not know
about, I guess the answer is no, you cannot create a formula that
references the Owner field. But perhaps someone else has an idea
for
you.
Hi,

Is it possible to refer to the Project Owner field in a formula
(Project
Entity custom field)?
How?
Thanks
.

.

 

[HansH]

This is probably the best approach.
To answer your original question: the Project Owner field is a
server-side only field and cannot be referenced in a formula or using VBA.
So you'll have to use a different approach.

Regards,
Hans

Projectopolis <http://msepm.hsquared.be>

 

[Andrew Lavinsky]

Pulled up my VPC, what about setting an Enterprise Text Field =[Project Manager]?

Then train everyone to fill out File > Properties, which is considered a
best practice anyway.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

...not to detract from Ben's suggestion, but there's already a free
text field which is called Project Manager and pulls from the File
Properties

Manager field. Then you'd have two fields, one called PM and Project
Manager

- which seems a bit inelegant.

Robert - have you tried grouping by the Project Manager field? The
only issue is that it's free text, but hopefully the PMs should be
able to enter their own name in a relatively standard fashion.

(That being said, I've been known to do the same thing as Ben
suggested.)

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi Robert,

I've simply done this by creating an Enterprise Project Text field
called PM associated with a lookup table. This is simple and
effective...

Thanks everybody,

What I would like to do is to make a grouping by Owner in the
File|Open
dialog of Project Pro 2007.
But I'm afraid we can do that only on custom fields with a lookup
table...
Thanks again for your help
".jussi" <[email protected]> a écrit dans le message
de
news: (e-mail address removed)...
Robert,

There are two caveats in using the author field. First, if you are
creating
your project from an enterprise template, the project author will
be
the
template author. Second, if you switch project managers, the author
will
not
be updated.
That said, if you give a bit more explanation of what you are
trying
to
do,
maybe someone will have a workaround for you.
Hope that helps,
- Jussi
-- http://finepm.blogspot.com/
:

Just thinking of a couple of options that I would try:

I don't have a copy of Project Server open in front of me, but the
task
level
field will reference [Author], which is a Project File Property.
Not
sure
if that can be surfaced into an Enterprise Project level field,
but
it's
possible. You might try that in an Enterprise field to see what
happens.
Author defaults to the person who created the project - so it's
almost
the
Owner field, depending on how much you change things after the
project is
created.
Your other option would be to somehow create an Enterprise field
that
pulls
the Status Manager(s) from the project and surfaces that at the
project
level.
According to most of the security structure, anyone with Status
Manager
rights would often have the same permissions as owner.
I can play with that next time I fire up a VPC.
What kind of formula do you wish to develop, out of curiousity?

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
Robert --

I just ran a quick experiment. To my surprise, I could not write
a Project field with a formula that references the Project Owner
field. I used the following formulas, both of which generated an
error:

[Owner]
[Project Owner]
So, unless this field carries some other name that I do not know
about, I guess the answer is no, you cannot create a formula that
references the Owner field. But perhaps someone else has an idea
for
you.
Hi,

Is it possible to refer to the Project Owner field in a formula
(Project
Entity custom field)?
How?
Thanks
.

.

 

[Robert]

Hi Ben,

In this company there are more than 250 Project Managers, with a hight
turn-over. I'm afraid it'll not be so simple... :-(
Thanks,

Hi Robert,

I've simply done this by creating an Enterprise Project Text field called
PM
associated with a lookup table. This is simple and effective...
--
Regards, Ben.

Thanks everybody,

What I would like to do is to make a grouping by Owner in the File|Open
dialog of Project Pro 2007.
But I'm afraid we can do that only on custom fields with a lookup
table...
Thanks again for your help


".jussi" <[email protected]> a écrit dans le message de
(e-mail address removed)...

Robert,

There are two caveats in using the author field. First, if you are
creating
your project from an enterprise template, the project author will be
the
template author. Second, if you switch project managers, the author
will
not
be updated.

That said, if you give a bit more explanation of what you are trying to
do,
maybe someone will have a workaround for you.

Hope that helps,
- Jussi

--
http://finepm.blogspot.com/


:

Just thinking of a couple of options that I would try:

I don't have a copy of Project Server open in front of me, but the
task
level
field will reference [Author], which is a Project File Property. Not
sure
if that can be surfaced into an Enterprise Project level field, but
it's
possible. You might try that in an Enterprise field to see what
happens.
Author defaults to the person who created the project - so it's
almost
the
Owner field, depending on how much you change things after the project
is
created.

Your other option would be to somehow create an Enterprise field that
pulls
the Status Manager(s) from the project and surfaces that at the
project
level.
According to most of the security structure, anyone with Status
Manager
rights would often have the same permissions as owner.

I can play with that next time I fire up a VPC.

What kind of formula do you wish to develop, out of curiousity?

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Robert --

I just ran a quick experiment. To my surprise, I could not write a
Project field with a formula that references the Project Owner
field.
I used the following formulas, both of which generated an error:

[Owner]
[Project Owner]
So, unless this field carries some other name that I do not know
about, I guess the answer is no, you cannot create a formula that
references the Owner field. But perhaps someone else has an idea
for
you.


Hi,

Is it possible to refer to the Project Owner field in a formula
(Project
Entity custom field)?
How?
Thanks


.

.