Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hello,
Is it supported to set a default format for parent/child rows? For example, when a row becomes a parent, automatically
Thank you,
Justin
1. Add a Checkbox column with this formula
=IF(COUNT(CHILDREN([Primary Column]23))>0,1,0)
for your Primary Column (change to your column name) and row 23 (then copy to the rest of the column)
This will be checked when the row has children.
2. Then set up Conditional Formatting for when the Checkbox is checked.
Craig
Craig beat me to it!
Hi Justin,
Yes this is possible with with some conditional formatting and som other tricks.
I'll get back later and write how it's accomplished.
Best,
Andrée
Thank you Craig!
Thank you.