The formula I'm using is: =COUNTIFS({OKS Satellite Accumulation Area Inspection Range 3}, "A-1", {OKS Satellite Accumulation Area Inspection Range 5}, "No") For some reason, when I add @row to both ranges, it comes back as unparseable
Thanks
@row doesn't seem to make sense here. It looks like you're using a cross-sheet reference. What your countifs should do is search an entire column (I'm assuming thats the "OKS Satellite Accumulation Area Inspection Range 3") and look for "A-1", then it searches another entire column "OKS Satellite Accumulation Area Inspection Range 5" and looks for a "No". That's what it's counting.
Hi Michael,
Yes, you are correct in you assumptions. Would there be a better option? I have multiple locations that are being inspected for multiple parameters
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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
