Simple Children / Parent question

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!

Tags:

Best Answer

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    edited 07/28/23 Answer ✓

    Hi leon_mc, 

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


    Hope it will work for you. 

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

Answers

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    edited 07/28/23 Answer ✓

    Hi leon_mc, 

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


    Hope it will work for you. 

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭

    Hi Leon,

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

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



    Gia Thinh Co. - Smartsheet Solution Partner.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!