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
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!