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.

Is there a way to flag a row if not indented

09/30/15 Edited 12/09/19

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

ProductX_example.jpg

Popular Tags:

Comments

  • John SauberJohn Sauber ✭✭✭✭✭

    This discussion might help you on your way.

     

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

  • 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 SauberJohn Sauber ✭✭✭✭✭

    Glad you're on your way!

This discussion has been closed.