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
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives