Range selection

Nevin LaBo

Hello,

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

Please advise.

 

Robert S.

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

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

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

 

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