Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Problem: Notify "Assigned To" user when a Web Form has been submitted
I have created a very simple action item tracker.
One requirement was I wanted to have an automated email be sent to a specfic team member when that member was assigned via the "Assigned To" field. ( Otherwise how do people know they have assignments? )
Next requirement was to use a Web Form to make it super simple to click a link in my toolbar, fill out the web form and be done. Slick!
I created a Column dedicated to each team member ( hidden ). This column would be set to "1" if the team member name is selected in the Assigned To column. Then create an alert if Any Change occurs on the Team Members Column. This works fine if I enter the data via the Grid. But if I use the Web Form SmartSheets will indicate each of these dedicated Team Member columns "has been changed" and every team member gets an email for ANY web form entry, regardless if they are the member selected in the Assigned To Field.
This seems like such an obvious thing to be able to do - but I'm beginning to think that without additional conditional logic for Alerts/Reminders it might not be possible today.
Has anyone found a solution for this scenario?
Comments
-
After continued investigation, it does appear Zapier has an integration which solves this particular siutation. Thanks to Craig Williams for posting numerous times about utilizing Zapier to solve certain problems. I'd still prefer a native SmartSheet solution since I'm already paying for one solution, but until that time this will probably do the trick.
-
Yea, that's the biggest hurdle right now...having multiple "apps" just to get this or that needed function and somehow persuading upper management to approve it.
Any chance Smartsheet can create an in-house solution
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives