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

ClanMcDe

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"))

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.