Email errors

neisdorfer

Good morning - since there isn't any way to have emails pop up from our enterprise list in a form and there isn't any way to validate emails entered in a form via a formula in another row in our sheet to alert us of any problems - is there any way to access a report and/or see when an automated email message doesn't work? For example - if I automatically send an email to a manager to alert them that they've received funding based on a funding allocation form and the executive assistant accidentally misspells the email do we have any way to know that happened?

Thanks!

Paul Newcome

If you have a list of all emails that are valid, you can use a formula in the sheet to flag rows that have an email not contained in the list.

neisdorfer

Unfortunately (or fortunately) we have over 50K people in our organization and they are constantly changing, no way to make that happen in any sort of resource efficient way.

Paul Newcome

IN that case unfortunately you are stuck with hoping for the best and submitting an entry (or voting for an existing one if someone else already has) in the new Ideas Topic.

https://community.smartsheet.com/categories/smartsheet-product-feedback-%26-ideas