DESCENDANTS function

Has anyone used the new DESCENDANTS function?

I have read the verbiage that SS has provided and played with it in the Formula Examples template from the solution center.

It is definitely working very differently than I expected it to.

Does anyone have some insight as to how this is supposed to be working and possibly some use cases for it/examples of it being used outside of what SS has provided?

Find more posts tagged with

Formulas

Comments

Kara Lumley

Thanks Paul, we are looking into this.

Best,

Kara

Sameer Karkhanis

Just posted this in another thread:

Based on the example for DESCENDENTS function/formula there is a potential bug in the value returned by this formula. Currently the value returned includes the parent row where as the actual value should exclude the requested row itself.

For example, below should return 3 for the formula COUNT(DESCENDENTS([Column Name]100) but currently it returns 4

where row 100 is

Task 100
- Sub Task of 100
  - Sub-sub Task of 100
    - Sub-sub-sub Task of 100

Kara Lumley

Hi all,

Thanks for letting us know!

We have a fix ready for this, and should know by Tuesday when we can deploy it. I'll update the thread then.

Thanks!

Kara

Paul Newcome

Awesome! Thanks, Kara!

Sign in to join the conversation!

Quick Links

Trending discussions

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet