Earliest Child Date when first cell is blank
I am trying to pull the earliest start date from the Child rows into the Parent row.
=MIN(CHILDREN([PWD Start - Days Remaining (Σ)]@row))
I thought this was working until I had no date in the first child row rather than a date.
If there is "No Start Date" in other cell accept the first one, formula seems to be working.
I tried to incorporate a COLLECT into the formula but can't seem to get the format correct.
Please see attached screenshots.
Answers
-
I am not able to replicate the issue you have displayed. Maybe there's a child linked to the parent with no days. Here are the screenshots from my test
Both the formulas below give the result
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Thank you very much for attempting to replicate my error.
I will attempt again to see if there is some other other data influencing the formula to not always report as expected.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!