Simple Children / Parent question

leon_mc

Hi all,

Apologies I took a break from working with SmartSheet for over a year and am slowly getting my memory back on how the formulas work.

I have column called Helper, and in the CHILDREN cells it may say "Yes" if certain criteria are met.

I want to have at the PARENT level, either in that column or a new Helper2 column, a "Yes" inserted if any of the CHILD values have a "Yes".

Can someone please help? Thanks!

Kaveri Vipat

Hi leon_mc, 

You can try this formula - =IF(CONTAINS("Yes", CHILDREN(Helper@row)), "Yes", " ") 

Hope it will work for you. 

Kaveri Vipat

Hi leon_mc, 

You can try this formula - =IF(CONTAINS("Yes", CHILDREN(Helper@row)), "Yes", " ") 

Hope it will work for you. 

Gia Thinh

Hi Leon,

Try this formula in the parent cell. Hope it helps.

=IF(COUNTIF(CHILDREN(), "Yes") >= 1, "Yes")