Checkbox if 2 Criteria Met from Different Sheet

I want to reference a sheet and look for a certain person in the Analyst column and look for a certain status in the Status column. If both conditions are met, I want the sheet with the reference formula to check a box. This is erroring out:

=IFERROR(IF(AND(INDEX({Analyst Support Request - Analyst}, ="Paul Smith", INDEX({Analyst Support Request Status}, ="In Review"), 1, 0), 0)))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!