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?

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!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 449 Global Discussions
- 154 Industry Talk
- 504 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 513 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives