Multi data report comparison
I am looking to identify when new items are added to a report. We receive a report bi-weekly and the goal is to 1. compare the new report the previous report to identify when new items that meet the filter conditions are met and 2. take the newly identified items against the assigned list and if not found, then add to the list. Is this possible to accomplish?
Answers
-
If you make a Record Date automation in the source Sheet(s) that mimics the report filter criteria you would have that info.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Normally I would complete a Power Query to append any new reports and filter out the duplicate items (i.e. the previous items) so that only the new items with my criteria are left. This would allow me to add those items to the list we use for assigning. Is there a similar capability in Smartsheet?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!