Include Previous Value in Workflow Notification
I have a sheet that has all of our current projects, and one of the columns is Ship Date. We have a workflow so that some of us are alerted when this Ship Date changes.
Currently, we just have the message saying "The ship date is now {{Ship Date}} for {{Job Name}}."
Is there a way to include the previous value (date) that was entered?
For example, "The ship date for {{Job Name}} has changed from {{Previous Ship Date}} to {{New Ship Date}}."
Answers
-
Hi @Kayla Wootten ,
I don't thank that's possible. The previous entry is stored in the cell history but there's no way to reference that in an automation.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
I hope you're well and safe!
Here's a possible workaround or workarounds
Please have a look at my post below with a method I developed. You could use it to store the previous value in a so-called helper column, and then you could include that in the alert.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå - brilliant. Bookmarked.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives