Is there a way to flag a row if not indented

Josh Townley

Hi all,

 

I'm fairly new to Smartsheet, and have been fiddling around with it on my own, trying to build a database to keep track of product registrations (see the screenshot below).

 

It uses three levels of heirachy:

- Product level

   - Country level

      - Application level

 

It's very large, with thousands of rows, and will be updated regularly by multiple users. My problem is that it hinges on users setting the correct heirachy level when adding a new row, or rows could easily get lost. I would love to find a way to flag a row if it hasn't been indented below the appropriate parent (so in the screenshot below, the bottom row, a new application for Hong Kong, should be flagged since it isn't indented)

 

The formula would need to be robust enough that I could copy / paste it down the whole column, then lock the column to prevent things going awry, like people clicking the flag on/off manually. It also needs to allow for inserting new rows for new applications (eg. above the new application for Hong Kong)

 

Unfortunately, there doesn't seem to be a way to count parent rows, and I haven't had any success with formulas counting child rows. It's quite likely that what I want to do is impossible, but I just thought I'd throw it out to the community to see for sure.

 

Thanks!

 

Josh

John Sauber

This discussion might help you on your way.

 

https://community.smartsheet.com/discussion/check-if-child-row

Josh Townley

After a bit of tinkering, I got a solution, thanks to your formula John. It's probably not the most elegant, but I added the 'Is grandparent?' column from your other thread, as well as another column to detect whether 'Application type' was empty or not. Since the 'Application type' column should only contain text at the grandchild level, a third column flags the grandparent row if any of its children have text in that column.

Thanks very much for your help!

John Sauber

Glad you're on your way!