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

Find more posts tagged with

Accepted answers

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.