Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Field formula

Field formula

Field formula

Hi guys,
I don't know if I'm off the topic...

I'd like to learning more about custom columns.
I'm having trouble with formula. I'm trying to created a formula that give me 3 possibilities.
Number 1 - If the start date for the task hasn't arrived, print "wait"
Number 2 - If the task has completed on the time from the finish, print "good"
Number 3 - If the task has completed with delay, print "bad".

Anybody Can help me out?

Sorry for my poor English

RE: Field formula

You cannot show "wait" or "good" in a number field. So, firstly you need text fields. You could combine all three into one text field that will show one of the options "wait", "good" "bad". I am assuming a couple of things:
1. You have saved a baseline.
2. When you say "task has completed on time", I am comparing Finish to Baseline finish. If they are equal, it is "good".
3. Complete with delay - I am again comparing Finish to Baseline Finish.

The formula below in a text field shows what you are looking for, based upon my assumptions above:

Switch([Start]>[Current Date],"Wait",[Finish]=[Baseline Finish],"Good",[Finish]>[Baseline Finish],"Bad")

What this formula is missing is what if the task finishes early (Finish < Baseline Finish) and any sort of degree of "bad".

RE: Field formula

Thank you for the quick replay Julie,
I'm really busy right now and don't have enough time to test the formula.

Thank you very much for the help.
I'll let you know if it worked.


RE: Field formula

Sure. Feel free to post back with further questions as needed.

RE: Field formula


I'm having problems with my formula if you don't mind helping.

I want an IIF to show me values based on different %complete &/or start date.

I'm not in work at the minute but just wondered whether you could help from here or do I start a new thread.

I would like
Value '1' if %complete = 100
Value '2' if start date < today but finish date > today and % complete = 0
Value '3' if start date < today but finish date > today and % complete > 0
Value '4' if start date > today but < today +14
Value '5' if start date > today + 15

Each of these would them result in a different graphical indicator.

I got a deadline in work and in my haste nominated myself to build into plan. Now realised a little more complex than I envisaged.


RE: Field formula

Is there a particular reason why you want an IIF and not a Switch? Post what you have so far and I'll try to help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close