Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How to distinguish normal rows from children rows?

Jan Schuster
edited 12/09/19 in Archived 2016 Posts



we are already using this checkbox-formula to autoformat parent rows:

=IF(COUNT(CHILDREN([Benötigte Innovation / Feature]13)) > 0, 1)


But now we want also to autoformat children rows, as a visual means in card view.

I found and experimented with some formulas in this board, but couldn't find a way to distinguish between normal rows and children rows.


Any ideas?


Thank you







  • Paulo Paiva

    I am realy interested to know if there is a solution for that.

  • Kennedy Stomps

    Hi Jan-- You could format the parent rows using Conditional Formatting to change the color of the colored left side of the card. This is currently the only way to format a card, though we are considering allowing row formatting to be represented on cards and I've added your vote for this to our enhancement request list. You'll want to set up a Conditional Formatting rule to be in effect when the box is checked, then choose your desired formatting color from the Task Bar dropdown. 

  • Kennedy Stomps

    I should add-- we don't support a formula or another means to determine whether or not a row is a child row at this point, so that's why I suggested formatting parent rows, rather than child rows!

This discussion has been closed.