Notification sent on selection of certain criteria from drop down menu

Louise O'Day

I have a sheet with a simple drop down menu.  I have a notification set up for my accounting department.  They only want to be notified once the "accepted" choice from the drop down menu is selected and not the other 4 choices. Is this possible.

Thanks in advance

 

Louise

 

Kennedy Stomps

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!