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.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!