Formula - Count IFS

Hello,

i am having trouble with a calculation I am trying to use. The formula is :

=COUNTIFS({Original Due Date}, >=[Column22]@row, {Original Due Date}, <=[Column23]@row, {Days for Deviation Closure}, >30, {Days for Deviation Closure}, <61)

The calculation does not give me an error (all results return as 0, however, if I use the filter function with the same parameters I get different results (a different number for each set of dates.

Does anyone happen to see what in the calculation may be prohibiting it to count correctly?

Thanks!.

Find more posts tagged with

Accepted answers

All comments

Dakota Haeffner

Hey Michelle,

Could we get some screenshots of the fields that are referenced in the formula?

michellelkirkland

Thanks for your quick response!

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.