First Entry Flag equation as column formula?

Your range references specific cells (Leader$1) so it can't be a column formula.

Your forumla worked for just finding duplicates as the ranges are the whole column

So I understand, when there is a duplicate value, you are looking to identify the first submission and mark it as , first entry , and then any subsequent duplicates , mark as duplicate?

Ok cool!

I would suggest creating a helper column which uses a =JOIN formula to join the three columns to create a single row value. At the moment you are counting the week, leader and commitment individually; these may all appear more than once in other row combinations that aren't values.

So

1.Helper column:

=JOIN(Week@row:Commitment@row)

2.Created date column

Add a created date column; this allows us to see date and time of entries

3.Duplicate Check Column

=IF(COUNTIFS([Join Column]:[Join Column], [Join Column]@row) > 1, IF(MIN(COLLECT([Created Date]:[Created Date], [Join Column]:[Join Column], [Join Column]@row)) = [Created Date]@row, "First Entry", "Duplicate"))

What this formula is saying is, if there is a duplicate value, return the oldest date/time that this duplicate value appeared. Then if that date/time matches the created date @ row, that is your oldest row and therefore the initial submission.

Hope that helps.

You have solved an issue I have been working on for over 4hours...thank you!