automatically apply =Min/Max of descendants formula to parent rows based on hierarchy number?
is there a way to make those 4 date columns automatically apply the min/max formula once hierarchy is changed to 2? converting to a column formula does not let me edit the white/blank hierarchy date columns. and i tried doing an automation workflow to change a cell value, and the date columns are not options (they are NOT restricted to dates only).
Answers
-
This would require automation, and automation does not allow inserting formulas. Instead it enters the formula as straight text.
Can't use a column formula because it would apply to all rows.
It would make for a good Product Idea submission if you can't find one already submitted that you can upvote.
Let me know if you enter or find one (share link), and I'd be happy to upvote it. I have needed this same functionality, and have searched far and wide to no avail.
All the best,
-Ray -
Oh, and you can alternately use the following:
=MAX(CHILDREN())
=MIN(CHILDREN())
Will yield same results as using descendants.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!