To Calculate the count of New Entries
Hi,
I'm Uploading the Attachment 4 times in a Day, I need to calculate the new rows added every time. Kindly suggest some logic to achieve this.
Example: At 10 AM, while Uploading Data, 2 rows are newly added, now count will be 2.
Again 2PM, while Uploading Data, 3 rows are added, now count will be 3. it should not show 5.
Thanks,
Sandhiya P
Best Answer
-
Hi @Sandhiya07,
Try this way.
You add a helper column "New row" and create 3 workflows.
1st change cell value workflow will change "New row" to "checked" when new rows are added
2nd change cell value workflow will run everyday on 11AM to unckeck all rows that have "checked" value
3rd change cell value workflow will run everyday on 3PM to unckeck all rows that have "checked" value
So before 11AM and 3PM, you can count all rows that have "checked" value
Hope that helps.
Gia Thinh Technology - Smartsheet Solution Partner.
Answers
-
Hi @Sandhiya07,
Try this way.
You add a helper column "New row" and create 3 workflows.
1st change cell value workflow will change "New row" to "checked" when new rows are added
2nd change cell value workflow will run everyday on 11AM to unckeck all rows that have "checked" value
3rd change cell value workflow will run everyday on 3PM to unckeck all rows that have "checked" value
So before 11AM and 3PM, you can count all rows that have "checked" value
Hope that helps.
Gia Thinh Technology - Smartsheet Solution Partner.
-
Hi @Gia Thinh
Thanks for your reply. It's working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!