IF/AND cross-sheet formulas


Hi there,

I'm getting error messages with my formulas and was hoping someone could help.

I'm trying to create a formula with the logic below:

  1. IF [Lot Number]@row in my target sheet = Lot Number in the my inventory form
  2. AND [Status] in inventory is "Approved"
  3. THEN check a box in my target sheet.

Whenever I try to reference another sheet for the second part I get error messages and it deletes the first part of my formula.

Any suggestions?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!