Min Collect Help - date returning zero value

Hello,

I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions?

=MIN(COLLECT({Project Plan - start date}, {Project Plan -workstream}, =[Column2]@row , {Project Plan - start date}, AND(NOT(ISBLANK(@cell )), @cell <> 0)))

Find more posts tagged with

Formulas

collect

dates

Accepted answers

All comments

Paul Newcome

Are you able to provide a screenshot of at least one row of the source data that should be getting pulled in along with a screenshot of the sheet this formula is on?

DKazatsky2

Hi @LSW,

What is "@cell<>0" trying to determine? It reads as if you are saying "if this date does not equal zero", which is not a valid formula.

This is at least contributing to your issue.

Hope this helps.

Dave

LSW

Hi @Paul Newcome Here is a sample. We do not have dates for all tasks yet, but I want to build the reporting on what we have so far. The intention is to report the date range (min/max) for the group of activities under the same workstream. I did try to remove the @cell<>0 that the AI formula maker gave me, but that did not fix the issue.

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.