Checkbox if 2 Criteria Met from Different Sheet

David Noël

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)))

Kelly Moore

Hey @David Noël

Here's a different approach

=IF(COUNTIFS({Analyst Support Request - Analyst},"Paul Smith",{Analyst Support Request Status},"In Review")>0,1)

Will this work for you?

Kelly

Kelly Moore

Hey @David Noël

Here's a different approach

=IF(COUNTIFS({Analyst Support Request - Analyst},"Paul Smith",{Analyst Support Request Status},"In Review")>0,1)

Will this work for you?

Kelly

David Noël

Perfectly and makes much more sense than the road I was headed down. Thank you!

David Noël

Kelly, thank you so much for your assistance. We implemented this and everything works great with one exception. The sheet the formula is on, auto checks the Start box on that sheet whenever an entry is made. We only want the checkbox to check looking back at the reference sheet. I hope this makes sense.