How to Identify New Rows Added by Data Uploader on Pivot Sheet
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!!
Best Answer
-
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
- When a new row is added to the sheet, Status is changed to New and conditional formatting changes to a different colour.
- Date Created automatically populates
- 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
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
Answers
-
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
- When a new row is added to the sheet, Status is changed to New and conditional formatting changes to a different colour.
- Date Created automatically populates
- 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
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
-
Excellent, thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 467 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!