Automated Alert - Send To Contacts In a Cell
Hello Smartsheets Community!
I have set up a simple automation to alert a contact in a cell that when a particular task within a project plan has been marked 100% to alert the contact in the assigned to cell. I tested out the automation by assigning someone to that particular task and they did not get the automation. Does anyone know why?
Below are screen shots of the automation and then one screen shot showing the task that is the condition is marked 100% and there is a name in the assigned to column (which is a contact column).
Any help is greatly appreciated.
Best Answer
-
Hey Anthony,
I believe the problem is on your condition block, as you can see you have it where the automation will only run if the task "contains" and then the text, because you used contain, you had to type or copied and pasted the text on the textbox value, there might be something different between that text and the text on your sheet, i would recommend you to use the "is one of" and then pick the value from the dropdown list on your condition block. That should get your workflow going, let me know if that worked for you.
Thanks
Answers
-
Hey Anthony,
I believe the problem is on your condition block, as you can see you have it where the automation will only run if the task "contains" and then the text, because you used contain, you had to type or copied and pasted the text on the textbox value, there might be something different between that text and the text on your sheet, i would recommend you to use the "is one of" and then pick the value from the dropdown list on your condition block. That should get your workflow going, let me know if that worked for you.
Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!