#NOMATCH returned on Sum(children())

Hi all,

I'm a bit puzzled.

I'm using this formula where H1 is a column that identifies titles (0 being a child, 1 up to 5 being the hierarchical level) to sum the cases that are reported from the second part of the formula (If (Site Management OR Alkalin), AND (not completed and due date within 30 days....) put 1

And the formula returns a #NOMATCH :( when I transform the formula into Column formula.

Making a cell formula again, does not correct the problem.

Very strange indeed.

Anyone to help me on this?

=IF([H1]@row <> 0, SUM(CHILDREN()), IF(AND(OR([Hub]@row = "Site Management", [Hub]@row = "Alkalin"), Status@row <> "Completed", [Due Date]@row < TODAY() + [Short Term Actions in Days]#), 1))

Thanks in advance for your help.

Raoul

Find more posts tagged with

Accepted answers

All comments

Louis Raoul

Just for the clarity,

the #NOMATCH appears only at Title level instead of the Sum(Children()) intended.
The column containing Site Management or Alkalin [Hub] is filled in with an Index/match - although I cannot see a relation between the error and the [Hub] column.

Thanks again for you help

Raoul

Louis Raoul

Hello again,

After a good night I looked at my problem again and found that it is far more simple than expected. There were a couple of #NOMATCH that I missed in a very long list. Hence the Sum(children()) providing a #NOMATCH as a result.

Not a big deal really.

What I learned here that is that Sum(children()) does not ignore #NOMATCH as it would ignore a simple text cell.

All the best

Andrée Starå

Hi @Louis Raoul

I hope you're well and safe!

Glad you got it working! Easy to miss!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.