IF formula for earliest date

Hi Community,

Could anyone please help with this formula syntax?

I want to capture what is the earliest date within a date range for a specific role, "Production" in this case.

=IF(Role:Role, "Production", COLLECT([Actual Start]:[Actual Start], [Actual Start]:[Actual Start], MIN([Actual Start]:[Actual Start])), "")

It would return the earliest date if a date is set and blank is no dates set yet.

Many thanks in advance for your input and your time.

Best,

Alessandro

Find more posts tagged with

Project Management

Accepted answers

Paul Newcome

Try something along the lines of...

=MIN(COLLECT([Actual Start]:[Actual Start], Role:Role, "Production"))

All comments

Paul Newcome

Try something along the lines of...

=MIN(COLLECT([Actual Start]:[Actual Start], Role:Role, "Production"))

Alessandro Terranova

Many thanks Paul! Much appreciated!

Paul Newcome

Happy to help! 👍️

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.