Identify "youngest" date from "Created Date" Column

Romano el Polako

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

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".

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!