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

 

 

 

 

· Share on FacebookShare on Twitter

Comments

  • Paulo Paiva
    Paulo Paiva ✭✭

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

    · Share on FacebookShare on Twitter
  • Kennedy Stomps
    Kennedy Stomps Employee

    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. 

    · Share on FacebookShare on Twitter
  • Kennedy Stomps
    Kennedy Stomps Employee

    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!

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories