IF Statements - looking up through CONTAINS

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

Best Answer

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Answer ✓

    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!


    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!