#INVALID COLUMN VALUE

Jeana

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

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.