Option to check parent rows only

Hello,

I am creating a checkbox in a column containing parent and child rows. I do not want the checkboxes for the children row to be an option. Only for the parent rows to be able to be checked. How can I action this?


Any help would be appreciated.

Best Answer

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Vinton Douglas

    What I'd do in this instance is add a Text character to the Child row checkboxes. This will get rid of the box to check for those rows:

    You could either manually do this, or you could set up a Workflow to add in a value if the row is a Child row. If you want to go the workflow route, you'll need a column that identifies if a row is a Parent or Child. For example:

    =IF(COUNT(CHILDREN([Primary Column]@row)) > 0, "Parent", "Child")

    Then you can set a Workflow so that when a row is added/changed and the Parent formula column adjusts to "Child", it enters your text value into the Checkbox column:

    See: Change the Value of a Cell in an Automated Workflow

    Cheers,

    Genevieve

  • Vinton Douglas
    Answer ✓

    Thanks much and appreciated.

  • Thanks much. This works for me