-
Are you able to pull emails from a Contact column?
I have a few sheets where I am needing to have the data Presented with the individuals name, then the email address in the column next to it. I have come across a few articles that have suggested having a helper 'Contacts Sheet' to reference w/ =INDEX({Contacts Sheet Email}, MATCH{Name@row, {Contacts Sheet Name}, 0)) for…
-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
-
Use Contact List (formatted column) as data source to lookup info
I have spent several hours searching for an answer to what I think should be something simple to do. I have a sheet with information related to a contact, (address, supervisor, ph numbers etc). All I want to do is reference the name in the Contact List (formatted column) to pull up other information related to that person.…
-
Mapping Azure AD Groups to Contact Groups with SCIM
I must dynamically provision contact group memberships from dynamic groups in Azure AD based on departments or projects. I usually use SCIM to map AAD groups to application groups in other enterprise applications. I don't see this ability in Smartsheet and would like to request this as a new feature. I would also be happy…
-
Only Unique Contacts Formula
I want to create a column formula that pulls all the contents of multiple contact cells @row and only print the contacts that are unique. I don't want to print the same contact in there twice if here happens to be duplicates. Additionally, this needs to be a "contacts only" field so we can reference this for alert…
-
Alert/Notification when line item hasn't been added
I am building a sheet in which 6 managers provide updates in the form of line items. Each week our Director reviews this sheet for the latest updates. I am looking to create a notification system that would go out to each manager that doesn't provide at least one update (add one line or modify an existing line) in the last…
-
Contact List Functionality in Forms
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
-
Cross-Referencing Assigned To Error
I am building out a roll-up sheet and have everything working nicely, with the exception of a single formula. The part of this sheet I'm having trouble with is in the image below. What I am trying to do is have this sheet look at the person named in the column "Primary", then check a couple other sheets to see how many…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Backspace Functionality on Contact Object
Personally, I am infallible and have no need to remove a single character that I have ever written. However, I am assuming the rest of your users may misspell a name on occasion, or perhaps misplace a '.' in an email address on occasion. For those unfortunate individuals that fall victim to their own imperfection, the…
