if function for 3 criteria

Swamfax
Swamfax
edited 12/09/19 in Smartsheet Basics

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!

Comments