I am trying to count if Lilly is the controller, and the status is not cleared or delivered. Having trouble with the formula.
=COUNTIFS(CONTROLLER:CONTROLLER, "Lilly Spanbauer", {status}, <>"Cleared", {status}, <>"delivered")
Are you getting an error or an incorrect count?
# invalid ref
Ok. What sheet is the data on? Is it on the sheet with the formula or a different sheet?
Same sheet.
Ok. In that case you will need to change the cross sheet references {status} to reference the STATUS column in the current sheet Status:Status.
OMG, Thank you I copied the formula and did not realize that. ty
Happy to help. 👍️
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.
