Countif checkbox not checked and frequency is not adhoc request or upon request.

I'm having trouble with a countif formula returning unparsable. I working with a metric sheet that counts tasks on another sheet where an Adhoc Request checkbox is not checked, and the task in the other sheet also has a frequency (dropdown list) that IS NOT "adhoc request" or "upon request". What am I missing here.

=COUNTIF({Analyst Request Tracker with Form Range 7}, Category60, =0), + NOT(COUNTIF({Analyst Request Tracker with Form Range 6-Frequency}, "Adhoc Request")) +NOT(COUNTIF({Analyst Request Tracker with Form Range 6-Frequency}, "Upon Request"))

Find more posts tagged with

Accepted answers

All comments

kira11

Hi!

I believe the issue is your hard coded Category60 and the syntax of the NOTs. If you are trying to have a single count value for a list of requests where the specified checkbox is unchecked and the Frequency is not Adhoc or Upon Request I would try:

=COUNTIFS(B@row, 0, C@row, AND(NOT(HAS("Adhoc Request", @cell)), NOT(HAS("Upon Request", @cell))))

ClanMcDe

https://community.smartsheet.com/discussion/comment/448785#Comment_448785

Thanks for the idea, unfortunate it did not work.

Brian_Richardson

=COUNTIFS({Analyst Request Tracker with Form Range 7},false,{Analyst Request Tracker with Form Range 6-Frequency},AND(NOT(HAS(@cell,"Adhoc Request")),NOT(HAS(@cell,"Upon Request"))))

@kira11 your HAS arguments were reversed…HAS and CONTAINS have opposite formats which annoys me to no end!

Paul Newcome

@Brian_Richardson "HAS and CONTAINS have opposite formats which annoys me to no end!"

ALL THE TIME!!! Ugh.

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.