Identify "youngest" date from "Created Date" Column

Hey Smart Heads,

I have another question about our beloved topic of formulas.

Background:

I have a autogerated column with row created date. In the file, rows are added in 2 ways:

In bulk, by senior auditor
Ad-hock by auditor

I would like to diferentiate these two types of inflow. I came up with an idea of finding "earliest" date from the column and convert "day" into benchmark, see:

=IF(MID(Created@row, 5, 1) > 1, "NEW", "BASIC")

This requires maintenance from sheet admin to validate results. There might be a scenario that audit started in June and was continued in July, hence more sophisticated solution would be appreciated.

Thanks in advance,

Romano

Find more posts tagged with

Formulas

Accepted answers

Nick Korna

If you have some sample data this is should be easy enough for you to test:

=IF(DATEONLY(MIN(Created:Created)) = DATEONLY(Created@row), "Basic", "New")

This will have anything put in on the earliest date show as "Basic", anything after that date would be "New".

All comments

Nick Korna

If you have some sample data this is should be easy enough for you to test:

=IF(DATEONLY(MIN(Created:Created)) = DATEONLY(Created@row), "Basic", "New")

This will have anything put in on the earliest date show as "Basic", anything after that date would be "New".

Romano el Polako

Hey @Nick Korna , outstanding, thank you very much!

It works perfectly, thanks,

Romano!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.