## Field formula

## Field formula

(OP)

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

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

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

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

## RE: Field formula

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

Thanks

## RE: Field formula

## RE: Field formula