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.
Conditional formatting based on location in hierachy
Please consider incorporating a functions level() and has_cildren() in the conditional formatting and reporting filters.
level() would give "0" if top level and "1","2" ... depending on the number of indentations.
has_children() retruns true or false.
Combined this would allow:
- making filtered reports only extracting entries without children (while this can be done today, it is cumbersome when you need to implement such a change to 50 existing lists. )
- consistent formatting across sheets as one can use the conditional formatting to for instance give all level 0 blue background and white text, all level one entries grey background on so on. To avoid formatting regular entries, the conditional formatting would only be applied to entries without children.
This would ease keeping plans clean and consistently formatted.