Countifs not working properly

Hi Everyone,

I'm looking to pull any trainings that were "Direct" from the Past 30 Days. Anytime I enter the formula it says #Unparseable. I'm not sure where I'm going wrong.

=COUNTIFS({Training Type Column}, "Direct", {Date Entered Column}, ">=" & TODAY() - 30)

Find more posts tagged with

#UNPARSEABLE

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @JHorrocks

Please try one of the following;

=COUNTIFS({Training Type Column}, "Direct", {Date Entered Column}, >=(TODAY() - 30))

=COUNTIFS({Training Type Column}, "Direct", {Date Entered Column}, >=TODAY(-30))

https://app.smartsheet.com/b/publish?EQBCT=3b8259601f2f476e915924b1defdc755

https://app.smartsheet.com/b/publish?EQBCT=814ef63fe2474e76b9880b2a10b6512e

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.