IF(AND with multiple sheets.


I am trying to have a check box mark if the following are true

  1. If the individual a review was completed about (sheet two) matches the individual name at the row
  2. The type of review completed (sheet two) equals the "Specific Review"

Example of what I had that is erroring.

=IF(AND({Data Collection All Reviews Range 1} = "First Review", {Data Collection All Reviews Range 2} = [Individual Name]@row), 1, 0)

#Invalid Operation is what I currently receive.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!