converting to a column formula
I am attempting to =IFERROR(SMALL([Lowest Quote]6:[Lowest Quote]9, 1), "") into a column formula I am unsure of the changes needed to make it work. I want to have the lowest quote in the children tasks to populate on the parent task bar.
Answers
-
Is this the type of thing you want to display?
Parent Rows collapsed:
Parent Rows expanded:
Those can't be column formulas because then the value needing to be entered into the Children rows couldn't be entered. They'd just be blank cells like this and not editable:
You can however enter this into each parent row's Lowest Quote cell:
=IFERROR(SMALL(CHILDREN([Lowest Quote]@row), 1), "")
Or you can make a column formula in a different column that is only used for the parent row's calculation formula. Like this:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!