Can someone please help me with this formula? I've worked on it since 7:30 am it's now 10:15 am.
=COUNTIFS({complaints Range 1}, NOT(ISBLANK(@row)), {complaints Range 2}, >=DATE(2023, 1, 1), {File a complaint Range 3}, <=DATE(2023, 12, 31))
convert to column formula, then add an iferror function
=IFERROR(COUNTIFS({complaints Range 1}, <>"", {complaints Range 2}, >=DATE(2023, 1, 1), {File a complaint Range 3}, <=DATE(2023, 12, 31)), "Bad Ranges")
Hey @FGCC Smartsheet
Can you share a screenshot please? It will make it easier to understand.
Also, what are you trying to achive?
try this:
=COUNTIFS({complaints Range 1}, <>"", {complaints Range 2}, >=DATE(2023, 1, 1), {File a complaint Range 3}, <=DATE(2023, 12, 31))
@SteyJ That returned an invalid argument.
@Itai
Range 1
Range 2
Range 3
I think the issue is with the NOT(ISBLANK()) - I would recommend to add a new column in the database where the range is with a simple formula that will return 1 if its not blank then you can use it as a criterion for this formula.
=IF([Column]@row = "", 0, 1)
@Itai You are also very helpful. Thank you!
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.
