Cell referencing in a IF(CONTAINS(OR())) statement

Miguel Lopes
Miguel Lopes ✭✭
edited 06/16/22 in Formulas and Functions

Hello everyone ,

I am trying to use the @cell operator in my sheet , but I am cross referencing sheets and getting an invalid operator I am wondering if I am using incorrect syntax within my function , or braking the rules of the language . If someone could help me correct the formula that would be great !



=IF(CONTAINS(OR("QC " = @cell, "Disposition" = @cell, "Delay" = @cell, "Pending" = @cell), INDEX(COLLECT({Status}, {Lot}, [Int Lot]@row), 1)), INDEX(COLLECT({Status}, {Lot}, [Int Lot ]@row), 1), "Not Started")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!