if function for 3 criteria

Swamfax

Dear, 

I am planning to write an if function for 3 criteria.

IF(AND([In Progress - Late]1 >= 1, [At Risk]1 >= 1),[In Progress - On Track]1>=1,) "Red","")

I know I am writing it wrong. Can anyone help me structure the formula please?

Cheers!

Andrée Starå

Hi,

What column types are you using?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. 

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

You just misplaced a comma is all...

 

On Track]1>=1,) "Red"

 

move the comma to the other side of the parenthesis.

 

On Track]1>=1), "Red"

Swamfax

Cheers mate for spotting that error.

Swamfax

Cheers for your response, the problem is solved.  

Andrée Starå

I'm always happy to help!

Have a fantastic weekend!

Best,

Andrée

Paul Newcome

Happy to help!