Can a notification workflow send the "changed from" data along with the new data?
Hello! We have a lot of notification workflows set up and it would be super helpful for the people being notified to get a snapshot of what the data was before it was changed, along with the new data that has been changed. Does anyone know if this is possible? Thanks in advance!
Answers
-
There's a workaround I've done before, but no core ability. First on your sheet you need to be using the Row ID automated column. Then you set up an automation to copy row to another sheet whenever X happens. Then on your core sheet, you can do a lookup to the 'copy to' sheet to INDEX over to the copy sheet and return the second to MAX (as the MAX would be the most recent version) value of whichever column using the Row ID.
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Hi Jason,
That's quite a workaround! I'll play around with that and see if I can get it to work like we need to. Thanks for the help!
Kelly
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives