DESCENDANTS function

Paul Newcome

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?

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!