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
Comments
-
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).
-
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
-
Is it possible to define the range as 2 columns? something like:
([Column Name]:[Column Name]+[Column2 Name]:[Column2 Name])
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 33 Webinars
- 7.3K Forum Archives