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?
Comments
-
Thanks Paul, we are looking into this.
Best,
Kara
-
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
- Sub-sub Task of 100
- Sub Task of 100
- Task 100
-
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
-
Awesome! Thanks, Kara!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!