Outline level field

Jan Téblick

I'm an (expert) Excel user, using Smartsheet now in our organisation for basic tracking functionalities.

It's a daily 'struggle' to understand the limitations of Smartsheet and try to keep the sheet basic and simple, but I'm quite enthousiastic about Smartsheet.

 

On the other hand, I really miss some (in my point of view) basic functionalities. Besides the lack of any excel-lookup-like functions (cfr vlookup(), match(), offset(), ...) , I really miss an "outline level" field/function.

 

The outline idea is really great and works like a charm, but if you use multiple outline levels, the overview is really gone. It would be absolutely nice if we could change the color of a row (by using the conditional format), depending on the level of indent/outline. But as far I understand, there is no way to get the level of indention. 

 

(I'm also playing with the live connector and without this field, I can't to anything with the connector).

Really strange that there is no function for this.

 

John Hammond

I built a formula which will when added to a checkbox field will check the box on parent rows. I then set a conditional formatting rule format the row when the box is checked. With this, all parent rows are automatically formatted. It cannot differentiate which level of parent it is but it will at least format all parent rows. 

 

Here is is:

 

=IF(COUNT(CHILDREN([Task Name]21)) > 0, 1)

 

[Task Name]21 is referencing the parent row primary column.