VBA Questions answered here ...

[quddusaliquddus]

http://excelvba.proboards42.com/index.cgi

 

[y7c4g2k5]

I need a formula that uses both the [% Complete] field and the [Summary]
field to place a word into a text field (custom field). Something that
will give me the word 'Book' in the text field if the task is 100%
complete or if the task is a summary task. I tried to use
IF([% Complete]=100,"Book","") or IIF([Summary]=Yes,"Book","") -
several variations but the summary task does not fill automatically.
Thanking you in advance

 

[Jan De Messemaeker]

Hi,

In the window defining the field customization, did you tell Project to use
the formula on summary tasks?

 

[y7c4g2k5]

This is applied to all tasks and subtasks in the project - I'm using a
text field and applying a formula to it to populate it if the activity
is 100% complete or if the task is a summary task. Thank you for the
response. Again the formula is: IIF([% Complete]=100,"Book","") or
IIF([Summary]=Yes,"Book","")

Hi,

In the window defining the field customization, did you tell Project to
use
the formula on summary tasks?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

I need a formula that uses both the [% Complete] field and the [Summary]
field to place a word into a text field (custom field). Something that
will give me the word 'Book' in the text field if the task is 100%
complete or if the task is a summary task. I tried to use
IF([% Complete]=100,"Book","") or IIF([Summary]=Yes,"Book","") -
several variations but the summary task does not fill automatically.
Thanking you in advance


--
y7c4g2k5
------------------------------------------------------------------------
y7c4g2k5's Profile: http://forums.techarena.in/member.php?userid=10274
View this thread: http://forums.techarena.in/showthread.php?t=74009
Free Computer Help - http://forums.techarena.in

 

[Rod Gill]

Try IIf([% Complete]=100 Or [Summary]=Yes,"Book","")

But as Jack has already said, in Customise Field dialog you must have apply
formula for Summary task as well otherwise it can't work

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

This is applied to all tasks and subtasks in the project - I'm using a
text field and applying a formula to it to populate it if the activity
is 100% complete or if the task is a summary task. Thank you for the
response. Again the formula is: IIF([% Complete]=100,"Book","") or
IIF([Summary]=Yes,"Book","")

Hi,

In the window defining the field customization, did you tell Project to
use
the formula on summary tasks?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

I need a formula that uses both the [% Complete] field and the [Summary]
field to place a word into a text field (custom field). Something that
will give me the word 'Book' in the text field if the task is 100%
complete or if the task is a summary task. I tried to use
IF([% Complete]=100,"Book","") or IIF([Summary]=Yes,"Book","") -
several variations but the summary task does not fill automatically.
Thanking you in advance


--
y7c4g2k5
------------------------------------------------------------------------
y7c4g2k5's Profile: http://forums.techarena.in/member.php?userid=10274
View this thread: http://forums.techarena.in/showthread.php?t=74009
Free Computer Help - http://forums.techarena.in

 

[Jan De Messemaeker]

Just for once, it was me not Jack.. )

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

Try IIf([% Complete]=100 Or [Summary]=Yes,"Book","")

But as Jack has already said, in Customise Field dialog you must have apply
formula for Summary task as well otherwise it can't work

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

This is applied to all tasks and subtasks in the project - I'm using a
text field and applying a formula to it to populate it if the activity
is 100% complete or if the task is a summary task. Thank you for the
response. Again the formula is: IIF([% Complete]=100,"Book","") or
IIF([Summary]=Yes,"Book","")

Hi,

In the window defining the field customization, did you tell Project to
use
the formula on summary tasks?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"y7c4g2k5" <[email protected]> schreef in bericht

I need a formula that uses both the [% Complete] field and the
[Summary]
field to place a word into a text field (custom field). Something
that
will give me the word 'Book' in the text field if the task is 100%
complete or if the task is a summary task. I tried to use
IF([% Complete]=100,"Book","") or IIF([Summary]=Yes,"Book","") -
several variations but the summary task does not fill automatically.
Thanking you in advance

------------------------------------------------------------------------
y7c4g2k5's Profile:
http://forums.techarena.in/member.php?userid=10274
View this thread: http://forums.techarena.in/showthread.php?t=74009
Free Computer Help - http://forums.techarena.in

 

[Rod Gill]

Darn, I hate it when that happens!! Sorry Jan!

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Just for once, it was me not Jack.. )

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

Try IIf([% Complete]=100 Or [Summary]=Yes,"Book","")

But as Jack has already said, in Customise Field dialog you must have apply
formula for Summary task as well otherwise it can't work

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

This is applied to all tasks and subtasks in the project - I'm using a
text field and applying a formula to it to populate it if the activity
is 100% complete or if the task is a summary task. Thank you for the
response. Again the formula is: IIF([% Complete]=100,"Book","") or
IIF([Summary]=Yes,"Book","")



Jan De Messemaeker Wrote:
Hi,

In the window defining the field customization, did you tell Project
to
use
the formula on summary tasks?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"y7c4g2k5" <[email protected]> schreef in bericht

I need a formula that uses both the [% Complete] field and the
[Summary]
field to place a word into a text field (custom field). Something
that
will give me the word 'Book' in the text field if the task is 100%
complete or if the task is a summary task. I tried to use
IF([% Complete]=100,"Book","") or IIF([Summary]=Yes,"Book","") -
several variations but the summary task does not fill automatically.
Thanking you in advance

------------------------------------------------------------------------
y7c4g2k5's Profile:
http://forums.techarena.in/member.php?userid=10274
View this thread: http://forums.techarena.in/showthread.php?t=74009
Free Computer Help - http://forums.techarena.in