Counting between dates greater than or less than a date

Hello,

I have the following formula coming back as unparseable. I am trying to calculate how many OOB Ambients in each month of the year. I normally have a date sheet that I reference, but I'm thinking using the date function might be cleaner. Can someone look at the formula below and identify my mistake?

=COUNTIFS({OS Visit Report Type}, "OOB", {OS Equipment Category}, "Ambient", {OS Activity Date}, >=(DATE(2022, 01, 01), {OS Activity Date}, <=DATE(2022, 01, 31)

Find more posts tagged with

Accepted answers

All comments

Michael Culley

You added a ( Before your first Date formula so smartsheet is looking for you to close that parenthesis. It's not needed so you can just delete it.

Michael Culley

You also need another parentheses at the end of your formula to close out your countifs. The parentheses that is there is only closing your 2nd Date formula.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.