Duplicates / Created Date And Modified Date

Marilen.Navarro103391

Hello. I hope you could help me.

This sheet is our tracker. I have a hidden "Duplicate Column" for any duplicate number in "Folder #" column.

I created two new columns, "Created Date" and "Modified Date". My problem is, I have not enter anything on the row but it has already an existing Created Date and Modified date. I show it's because of the duplicate formula. Hope you can solve my problem. Thanks.

Paul Newcome

If you set the formula as a column formula then you shouldn't have to pre-populate any rows.

Paul Newcome

Right click on any cell containing the formula then select the option (near the bottom of the menu) to convert it to a column formula. From there you can delete all of the unfilled rows and any new row added will automatically have that formula in that column.

Paul Newcome

If you set the formula as a column formula then you shouldn't have to pre-populate any rows.

Marilen.Navarro103391

@Paul Newcome Kindly advise me the steps/formula. Thanks.

Paul Newcome

Right click on any cell containing the formula then select the option (near the bottom of the menu) to convert it to a column formula. From there you can delete all of the unfilled rows and any new row added will automatically have that formula in that column.