Field formula

[FabricioC84]

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

 

[JulieInMaine]

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".

 

[FabricioC84]

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.

Regards
Fabricio

 

[JulieInMaine]

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

 

[Sharkiness]

Hi,

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.

Thanks

 

[JulieInMaine]

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.

 

[JulieInMaine]

I see you have your answer at:

http://answers.microsoft.com/en-us/...-formula/2746ca28-b358-4427-86c5-66f4ae421776