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