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.
Notification sent on selection of certain criteria from drop down menu
Comments
-
Great question, Louise! Smartsheet doesn't have conditional notifications yet (though it is on the Product Roadmap), so it wouldn't be possible to set this up exactly as you've described it, but I think there's a simple workaround that could achieve a similar result.
I would suggest creating a checkbox column anywhere on your sheet, then adding an IF formula to the column to check the box when the value in the status choice column is "accepted". The formula would look something like this:
=IF([Drop Down Column] = "Accepted", 1, 0)
Then, set up a notification to email the accounting department when the checkbox column changes. You can actually hide the checkbox column after you've created it and added the formula, as it'll still trigger the notification regardless.
Hope that helps!
-
Thank you. Thank you. Simple yet very effective!!
Still trying to get my head around all the formulas!
-
No problem! Always happy to help
Have you checked out the Formula Examples sheet? I reference it all the time when I'm setting up my sheets--it's a great way to see exactly how something works and experiment with changes. I'd definitely recommend checking it out if you haven't already!
-
Hi All,
As mentioned, we're actively working on this feature. If you have ten minutes to spare, we'd love to get your participation in a usability study we're running.
For more information, see this annoncement:
https://community.smartsheet.com/announcement/weigh-smartsheets-next-strategic-feature
-
This feature was requested and it was indicated 2.5 years ago (8.4.15) that it was on the product roadmap. What does this actually mean, on the product roadmap. Do we have to wait another 2.5 years before this is implemented, 5 years?
I'm not trying to be difficult, but I am trying to evaluate your employees feedback with some optimism when I read a comment that seems to address our needs, yet we have this open ended, non-commital sort of answer that you, smartsheet employees would likely not accept yourselves as an OK answer.
To a laymen it seems like an easy trigger, alerting on a value in a column. But thats a lesser concern, the real concern is what do the community managers words actually mean to users of Smartsheet?
I look forward to a thoughtful response.
-
Hi Eric,
We're working hard to test this feature and bring it into the app as soon as it's ready. We're hoping to have this out for our March release (likely mid-late March), but we don't have a concrete timeframe. Just like with most development work, we could run into circumstances that would cause the feature to be delayed.
-
Did this feature make it for release in March as it is now September and I really need to be able to send email notifications when a certain drop-down value is selected?
-
Did this feature make it for release in March as it is now September and I really need to be able to send email notifications when a certain drop-down value is selected?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives