Is there a way to set up a statement based on whether or not a cell is a "Parent?"

If X cell is a "Parent" cell, I want the data outcome in Y cell to be 1.

If X cell is not a "Parent" cell, I want the data outcome in Y cell to be 0.

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Sarah Tavarez

    I usually add a so-called helper column called Level with the formula below, and then you can use it to identify parents and use it for conditional formatting and more.

    =IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)

    Would that work/help?

    I hope that helps!

    Have a fantastic day & Happy New Year!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!