How to Identify New Rows Added by Data Uploader on Pivot Sheet

Andy Lorance

Hello -

We load a large amount of data onto several sheets via the Data Uploader and Pivot apps. Looking for a way to identify newly added rows from one upload/pivot process to the next. We can handle this on the source data prior to the upload process, but hoping to make the process within Smartsheet to save some steps.

Thanks in advance!!

Purnima Gore

Hi @Andy Lorance

You could add two columns called Status and Date Created and Date Created_1

When you upload rows you can set off the following automation

1. When a new row is added to the sheet, Status is changed to New and conditional formatting changes to a different colour.
2. Date Created automatically populates
3. Date Created_1 has the formula =DateOnly([Date Created])

Then the next actions are whatever you want to do so for example, if you then want the status to change back to blank after a period of time has elapsed then set an automation that when a date is reached on a particular then it changes the field back to blank?

Hope that helps.

Kind regards

Purnima

Purnima Gore

Hi @Andy Lorance

You could add two columns called Status and Date Created and Date Created_1

When you upload rows you can set off the following automation

1. When a new row is added to the sheet, Status is changed to New and conditional formatting changes to a different colour.
2. Date Created automatically populates
3. Date Created_1 has the formula =DateOnly([Date Created])

Then the next actions are whatever you want to do so for example, if you then want the status to change back to blank after a period of time has elapsed then set an automation that when a date is reached on a particular then it changes the field back to blank?

Hope that helps.

Kind regards

Purnima

Andy Lorance

Excellent, thanks!