Formula for Overall Summary of Project Status

B

Betsy Yonn

Can anyone help me with this formula for a custom field? I have a
couple others that are similar for Work and Cost so if I can get help
with one, I can figure out the others. I need the Indicators to be
RAG but will need for text to also be added if it can be so when the
report or view is printed on b/w copy where you can't tell the color
of the Indicator, you can see the text value. I'm just having a hard
time wrapping my head around these formula's and expressions and I
haven't seen any books specifically addressing formula's.

(Finish Date - Baseline Finish) If > 0 then "Ahead of Schedule", If =
0 then "On Schedule", If < 0 then "Behind Schedule"

Thank you so much for any assistance you may be able to provide.
~Betsy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top