Formula calculating slack time greater than or less than a number

[Michael Gwin]

I searched for a couple hours and learned alot. I love this site. I tried
figuring out this seemingly simple formula and just cant get it to do what I
want....I need help.

I want to ultimately color code the tasks I have that are approaching
critical path. What I want is, if Total Slack time is greater than 0 days
and less than 5 days, show Yes in the Flag field. I plan on then taking the
flag field and color coding the text in the Task Name field (which I havent
learned yet either) and I might play with the color of the gantt chart bar.

Heres what I think should work:
IIf(0<[Total Slack]<5, Yes, No) but it marks everything Yes....
Also tried IIf((0<[Total Slack]<5), Yes, No)
Tried a bunch of other longer ones and with Text fields.

Please help.

 

[Mike Glen]

Hi Michael,

Welcome to this Microsoft Project newsgroup

I'm no expert in programming, but try: IIf([Total Slack]<5, Yes, No)

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[Michael Gwin]

The problem is I dont want it to include Total Slack of 0 or less since that
is my critical path. Im trying to find the next tasks that will impact my
critical path if I dont manage them closely. Does that make sense? So i
want greather than 0 and less than 5 days slack.

Thank you for the help!

Hi Michael,

Welcome to this Microsoft Project newsgroup

I'm no expert in programming, but try: IIf([Total Slack]<5, Yes, No)

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

I searched for a couple hours and learned alot. I love this site. I tried
figuring out this seemingly simple formula and just cant get it to do what
I
want....I need help.

I want to ultimately color code the tasks I have that are approaching
critical path. What I want is, if Total Slack time is greater than 0 days
and less than 5 days, show Yes in the Flag field. I plan on then taking
the
flag field and color coding the text in the Task Name field (which I
havent
learned yet either) and I might play with the color of the gantt chart
bar.

Heres what I think should work:
IIf(0<[Total Slack]<5, Yes, No) but it marks everything Yes....
Also tried IIf((0<[Total Slack]<5), Yes, No)
Tried a bunch of other longer ones and with Text fields.

Please help.

 

[Mike Glen]

Hi Michael,

It makes sense, but why not use a filter? Use Total Slack is less than or
equal to 5d AND Total Slack is greater than 0.

Mike Glen
Project MVP

The problem is I dont want it to include Total Slack of 0 or less since
that
is my critical path. Im trying to find the next tasks that will impact my
critical path if I dont manage them closely. Does that make sense? So i
want greather than 0 and less than 5 days slack.

Thank you for the help!

Hi Michael,

Welcome to this Microsoft Project newsgroup

I'm no expert in programming, but try: IIf([Total Slack]<5, Yes, No)

FAQs, companion products and other useful Project information can be seen
at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

I searched for a couple hours and learned alot. I love this site. I
tried
figuring out this seemingly simple formula and just cant get it to do
what
I
want....I need help.

I want to ultimately color code the tasks I have that are approaching
critical path. What I want is, if Total Slack time is greater than 0
days
and less than 5 days, show Yes in the Flag field. I plan on then
taking
the
flag field and color coding the text in the Task Name field (which I
havent
learned yet either) and I might play with the color of the gantt chart
bar.

Heres what I think should work:
IIf(0<[Total Slack]<5, Yes, No) but it marks everything Yes....
Also tried IIf((0<[Total Slack]<5), Yes, No)
Tried a bunch of other longer ones and with Text fields.

Please help.