Hello all
I'm trying to count how many pending tasks with team 3 for site 1
I'm using this formula but it's not working, please help :)
=COUNTIFS(Site1:Site8, HAS("Site 1"), [Task status]1:[Task status]8, "Pending"), Team1:Team8, "team 3")
Hey @Evan M.
Try this
=COUNTIFS(Site:Site, HAS(@cell, "Site 1"), [Task Status]:[Task Status], "Pending", Team:Team, "Team 3")
cheers
@Kelly Moore thank you very much it worked!
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.
