nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

How to reference to the last row of a colum?

Risto Nykanen

Hello,

I have sheet to where I add rows with a smartsheet form so the number of rows increases. At the top of the sheet I have a metrics section where I want to sum (with a SumIF function) the rows starting from row 10 to the last row. How can I do that?

Thanks,

Risto

Find more posts tagged with

Formulas

Comments

Andrée Starå

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

Paul Newcome

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.

Andrée Starå

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!

Paul Newcome

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

BSADK

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?

Sign in to join the conversation!

Quick Links

Trending discussions

Recurring Request for Update Keeps Disappearing
We set up a recurring Request for Update for each project when it starts. In the top row of the sheet, we use the feature to send an email at 8am every Friday morning. The past several months we have heard from various people each Friday they are missing one or more of these emails requesting an update. When we look at…
Find MAX non-blank cell with matching criteria
Hi all! I'm working on a column formula that will check whether the Column2ref cell in the current row is blank. If it is blank, the formula finds the maximum value in the ID column where the Trainer Name matches the Trainer Name cell value in the current row and the ID cell value is less than the ID cell value in the…
How to restrict sub-action due dates in a Smartsheet Form?
Hi Smartsheet Community, I'm working on an action management system where users create sub-actions through a Smartsheet Form. The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date. For example, if the parent action is due on June 30, 2027, users should not be able…