Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
I am trying to count a certain topic by a certain date range. I cant figure out what is wrong with my formula
=COUNTIFS({OSH Tracker Rules Range 1},"Open",IF({OSH Tracker Rules Range 2},DATE[23, 01, 01] DATE [23, 12, 31])
Hi Adina, I notice there are a number of issues in your date range formula. In short, your formula should be similar to the following after rectification.
=COUNTIFS({OSH Tracker Rules Range 1},"Open", {OSH Tracker Rules Range 2}, >=DATE(2023, 1, 1), {OSH Tracker Rules Range 2}, <=DATE(2023, 12, 31))
--Anson
This is amazing! Thank you. I knew there was a < and someplace but i was having a hard time getting it in there correctly.
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.
