Display old/new information in notification

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

  • James Keuning
    James Keuning ✭✭✭✭✭

    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.