IF/AND cross-sheet formulas
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:
- IF [Lot Number]@row in my target sheet = Lot Number in the my inventory form
- AND [Status] in inventory is "Approved"
- 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.
Help Article Resources
Check out the Formula Handbook template!