Earliest Child Date when first cell is blank

cindyalexander

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.

Find more posts tagged with

Accepted answers

All comments

AravindGP

Hi @cindyalexander

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

cindyalexander

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.