COUNTIF problem

Disregard. The problem was additional dates on collapsed child rows.

Thank you.

Good afternoon.

I have created a metric sheet that was then used to create a chart. The formula is written as: =COUNTIF({Date of Visit}, IFERROR(YEAR(@cell ), 0) = Year@row ) This was then drug down for 4 rows. Rows 1, 2, and 4 have the correct total. Row 3 is giving a total of 40 and it should also be 29.

Does anyone know what the problem may be?

Thank you.

Sue

Find more posts tagged with

Formulas

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @Sue Danielson

I do not see a problem with your formula. It works fine.

https://app.smartsheet.com/b/publish?EQBCT=443dba9eb3b647bebce006971bf3d118

https://app.smartsheet.com/b/publish?EQBCT=2e424a4ec41b478b89c828f3c388094b

One possible cause is that, far down the Date of Visit sheet, you have unnoticed 2024 rows.

Then, the metric sheet gets 40 in the 2024 row.

When I remove rows 130-140 or change them to 2026 dates, the sheet shows the 29 count value again.

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