IF Statements - looking up through CONTAINS

MegBurns23

I am getting an #IncorrectArgumentSet on this formula. I do realize I am trying to include a lot here.

What I am trying to do: Create an if statement that marks LATE if true, and On Time if false with two criteria: 1. looking up via Contains to make sure the project name is taken into account 2. if there are any lates within that project range. Any help is much appreciated.

#IncorrectArgumentSet formula:

=IF(AND(CONTAINS([Project Name]@row, {Tracker - Range 2})), (CONTAINS("LATE", {Tracker - Range 5})), "LATE", "On Time")

Kaveri Vipat

Hi MegBurns23 

Please you can try this formula  

=IF(AND(CONTAINS([Project Name]@row, {Tracker - Range 2}), CONTAINS("LATE", {Tracker - Range 5})), "LATE", "On Time")  

I hope this helps!

MegBurns23

Anyone, help?

Kaveri Vipat

Hi MegBurns23 

Please you can try this formula  

=IF(AND(CONTAINS([Project Name]@row, {Tracker - Range 2}), CONTAINS("LATE", {Tracker - Range 5})), "LATE", "On Time")  

I hope this helps!

MegBurns23

Oh my, I got lost in ()s, thank you so so so so much!