Cross Sheet Countifs w/ Checkbox

I am trying to write a cross sheet countifs formula.

(COUNTIFS({Ref. Sheet Column}, [Requirement Name]@row , {Ref Sheet Checkbox Column}, 1 > 0)

Something isn't right as I am expecting to return a checkbox on the target sheet where the formula is being written based on the conditions of the source sheet.

Thank you

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

If you want to check a box if at least one row matches your criteria, you would use an IF/COUNTIFS combo.

=IF(COUNTIFS(…………….) > 0, 1)

All comments

Paul Newcome

If you want to check a box if at least one row matches your criteria, you would use an IF/COUNTIFS combo.

=IF(COUNTIFS(…………….) > 0, 1)

Smar Czar

Thank you @Paul Newcome

Paul Newcome

Happy to help. 👍️

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.