Triggering an Alert When Data in a Cell Changes
Is there a way to trigger an automation in Smartsheet when data in a cell has been changed from one thing to another after rows are added to a sheet? I keep trying to set up an automation to trigger a reminder (see below) but there doesn't seem to be a condition that matches what I need.
I need SS to send me an email when one of these cells is changed from one person to another...
But the condition doesn't have "is changed" option or one that best fits.
Any ideas on how to fix this?
Answers
-
So the row is coming to the sheet with one of these roles assigned, "Writer", "Assessor", or "Reviewer", but then the status is changed, so that a different role is assigned to that role? I assume you then need to alert that person to their task because it wasn't initially assigned to them?
How is the role being changed? Is it being done manually?
-
So when the row initially comes to the sheet it's blank and we add in a person (value) to each of those cells. However, we need to create a "speed-bump" reminder to edit other cells in that row when that initial value is changed (or when the reviewer, writer, or assessor is changed from one value to another).
Help Article Resources
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
Check out the Formula Handbook template!