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.

Range selection

Options
Nevin LaBo
edited 12/09/19 in Archived 2017 Posts

Hello,

I am wondering how to choose a range on Smartsheet that will go on forever?

Please advise.

 

Comments

  • Robert S.
    Robert S. Employee
    Options

    Hello,

     

    There are two main ways to reference ranges that you can add to and the formula will include that data. Here's a help center article with more information on all of the different ways to reference within formulas in Smartsheet (https://help.smartsheet.com/articles/2476171#reference).

    The first of these two ways would be to reference an entire column, rather than a set range of rows for example row 1 to row 10.

     

    A range of rows would look something like this when referenced:

    [Column Name]1:[Column Name]10

     

    Referencing an entire column can be done by removing the row numbers, like this:

    [Column Name]:[Column Name]

     

    The second way to accomplish this would be to use hierarchy (https://help.smartsheet.com/articles/504734). You can indent all of the rows you'd like to have in your range under a row directly above the range. For example, if the range you'd like in your formula is rows 10 through 20, you can indent these rows under row 9. You can then write your formula with a reference such as this:

     

    CHILDREN([Column Name]9)

     

    This will look at all of the children of row 9 for that column. If you're like to add a new row to this range, you can add the row anywhere under row 9 and above row 22 and indent it into row 9's children. More on this can be found here as well (https://help.smartsheet.com/articles/2476171#hierarchy).

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Be aware: A main drawback to hierarchy formulas is when using Forms to add new rows to the bottom of the sheet. New rows are not auto-indented.

    Craig

  • Randy Van Winkle
    Options

    Is it possible to define the range as 2 columns?  something like:

     

    ([Column Name]:[Column Name]+[Column2 Name]:[Column2 Name])

This discussion has been closed.