Ok, pulling out hair trying to get contains in children to work

vanZylin

Column L44 with groups. ultimately ends up inside an if, but just trying base formula to eliminate everything else.

#UNPARSEABLE

=CONTAINS("In", CHILDREN(L44))

=CONTAINS("In", CHILDREN(L44@row))

#INVALID COLUMN VALUE

=CONTAINS("In", CHILDREN())

Neil Watson

@vanZylin the CONTAINS function is used within another function as per the help article https://help.smartsheet.com/function/contains?frame=0&nav=1

Depending what you are looking to achieve, a few options below:

Paul Newcome

Are you able to provide some screenshots for context?

vanZylin

Paul Newcome

Are you sure you are putting it on a parent row, and how are you using this after the CONTAINS function? The above screenshot should be working.

vanZylin

I know it should be working - that's why I'm pulling out hair...

Anyway, created new sheet (screenshot below), very simple very rudimental. Still getting errors on contains.

Neil Watson

@vanZylin the CONTAINS function is used within another function as per the help article https://help.smartsheet.com/function/contains?frame=0&nav=1

Depending what you are looking to achieve, a few options below:

Paul Newcome

CONTAINS will output a true/false value, so it can be used as a standalone in a checkbox type column. If it is not used in a checkbox column, it will need to be used inside of another function. If you run into another issue where a part of a formula is not working, it helps to provide screenshots as well as the entire formula for context.