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

Hi,

 

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

Jan

 

 

 

 

Comments

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

  • 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. 

  • 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.