Duplicate row, change Status column to "inactive" based on date feild

pageella

I have a list of names and would like to change the status of old rows to 'inactive' when a new submission for that name comes in. So only the most recent submission stays as active

Thanks!!

Paul Newcome

I would suggest inserting an auto-number column (called "Auto" in this example) and then use a formula along these lines in the [Status] column:

=IF(Auto@row <> MAX(COLLECT(Auto:Auto, [Name Column]:[Name Column], @cell = [Name Column]@row)), "Inactive", "Active")

pageella

Seems to be working - thanks! For my understanding.. what is this formula actually doing?

pageella

Does it matter if new rows are added to the top or the bottom of the sheet?

Paul Newcome

The formula compares the Auto-Number column to the highest number from that column for that name. If the auto-number on that row is not the highest auto-number for that name, it flags it as inactive. If it is the highest auto-number for that name, it flags as active.