Dates of Parent

so I am looking to make something and I cant seem to find what I need.
I would like to use
EXAMPLE
Parent Date | =last date entered below or keep blank tell all Childs are filled in
Child Date 1 | 1/1/22
Child Date 2 | 12/25/21
Child Date 3 | 11/9/21
Child Date 4 | Blank
i know =MAX(CHILDREN()) will kind of work but it wont leave it blank
Best Answer
-
Hey @Alex Klingbeil,
One solution is to include an IF statement with a COUNT to compare the number of CHILDREN from one column to the other. If they match it will continue with the MAX formula and if they don't it will return blank.
=IF(COUNT(CHILDREN(Date@row)) = COUNT(CHILDREN([Column A]@row)), MAX(CHILDREN()), "")
Answers
-
Hey @Alex Klingbeil,
One solution is to include an IF statement with a COUNT to compare the number of CHILDREN from one column to the other. If they match it will continue with the MAX formula and if they don't it will return blank.
=IF(COUNT(CHILDREN(Date@row)) = COUNT(CHILDREN([Column A]@row)), MAX(CHILDREN()), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!