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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!