Option to check parent rows only

Vinton Douglas

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.

Vinton Douglas

Thanks much and appreciated.

Genevieve P.

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

Thanks much and appreciated.

Vinton Douglas

Thanks much. This works for me