Dependencies choking date formulas

Is there any work around to keep date dependencies and still run calculations using those columns? Before dependencies were enabled my formulas worked fine to support my dashboard. Do we need additional helper columns?

=COUNTIFS({IMPACT}, Metric@row, {END} >=(2021, 10, 1), {END} <=(2021, 12,31), {STAT}, "In process")

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try using the DATE function. You are also missing a couple of commas.

=COUNTIFS({IMPACT}, Metric@row, {END}, >=DATE(2021, 10, 1), {END}, <=DATE(2021, 12,31), {STAT}, "In process")

Tina Rustvold

Oh goodness--time to update the glasses. Thank you!

Paul Newcome

Happy to help. 👍️

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.