Display old/new information in notification
Kate Kelley
✭✭✭✭
We are using a notification to let a team member know when we've updated information (date/time/etc). Is there a way to display the old information and the new information in the cell in the notification email? Possibly a strikethrough with the old information?
I'm sure this has been asked/answered but I was not finding it, so apologies for the duplications!
Answers
-
Not without storing that old information somewhere. I accomplish this by keeping Sheet1 with a Primary Key field, and Sheet2 with all of the updates (each update has a date). Then I have two columns in Sheet1 and use LARGE to get the top two records based on date.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives