#INVALID COLUMN VALUE

How can I get rid of the error I'm getting using this formula? I realize that one column type is a checkbox and the other is a text/number. Is there a way to eliminate the "#INVALID COLUMN VALUE" that is displayed. The formula is doing what I want it to do other than that.

Appreciate any help I can get on this.

=(INDEX(CHILDREN([Link]@row), COUNTIFS(CHILDREN([Done@row), 1)))

Thanks,

Jeana

Find more posts tagged with

Accepted answers

All comments

Ameya Athalye

Add IFERROR around your formula

=IFERROR((INDEX(CHILDREN([Link]@row), COUNTIFS(CHILDREN([Done@row), 1))), " ")

Jeana

I tried both of these and still get same error? Any ideas?

=IFERROR(INDEX(CHILDREN([Link]@row), COUNTIFS(CHILDREN([Done]@row), 1)), "")

=IFERROR((INDEX(CHILDREN([Link]@row), COUNTIFS(CHILDREN([Done]@row), 1))), " ")

Could it have to do with the Column formats? One being Text and the other a Checkbox?

Ameya Athalye

It could be, one thing to check

If you have row hierarchy, meaning you have a parent and children row setup. The CHILDREN formula will only work then.

If you could share a screenshot and give more context of what you're trying to do, that'd be helpful.

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.