How to reference to the last row of a colum?
Comments
-
Hi Risto,
You can use the new function that was just released called DESCENDANTS.
DESCENDANTS([parent_cell])
More info: https://help.smartsheet.com/function/descendants
Would that work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andree,
Do you know where I can find an explanation of what is considered a "descendant"? I have been playing with this to figure out exactly what all is encompassed by this function, but the results I am getting... I can't interpret them to simplify it for others because it's just not making sense to me.
-
The description in the Function List is the best I've found, and I haven't had time to play around with it yet.
https://help.smartsheet.com/function/descendants
Used within another function to reference all descendant rows of the referenced cell of the parent row.
The parent cell for which you want to return all descendants. If no cell is specified, the function references all descendants of the current cell.
Hope that helps!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I read that and even played with it in the Formula Examples Template to get a feel for it. It was definitely behaving quite unexpectedly in my opinion. I may start a new thread on it to see what other people have to say about it.
Thanks!
EDIT:
Here's the thread if anyone wants to add their input or follow along out of curiosity...
https://community.smartsheet.com/discussion/descendants-function
-
I don't see how descendants() can be used to answer the original question?
Similar to the original, I need to reference a range from the next row to the last row. This is regardless of parent/child relationships. This particular sheet I'm using has no parent/child relationships actually. How would I reference the last row that has data?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!