-
contact
-
Index/Match Formula Referencing Contact Columns Providing Wrong Values
I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for…
-
Contact list in Smartsheet after importing data
I am running into an issue where I import a group of names assigned to a certain task in Smartsheet. The list of names comes from an excel spreadsheet as multiple agencies must provide their inputs and not all have Smartsheet access (the Smartsheet in question is only for my agency's use). Well after importing the updated…
-
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…
-
Please enable us to select multiple contacts when sharing (was avialable a year or so ago)
About a year or so ago, if you wanted to share anything in Smartsheet, you had the ability to bring up your entire contact list or type a keyword, you would then be able to select multiple contacts to share with the same customize message. Please bring that back. It is a much-missed function. Thank you!
-
How to extract email address from a contact list the use the value in an adjacent column
Up until now, I have copied/pasted the email address manually. Nevertheless, our database has grown so much. I've tried the below formula: =IFERROR(SUBSTITUTE(SUBSTITUTE(MID([🎓 Student]@row, FIND("<", [🎓 Student]@row) + 1, FIND(">", [🎓 Student]@row) - FIND("<", [🎓 Student]@row) - 1), "<", ""), ">", ""), "") but after…
-
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
-
Why isn't my email notification being sent?
I have an automated workflow set up to alert someone (several people), triggered to run once at a specific time. I need it sent to notify people to complete a form. I tested it several times when setting the sheet up by sending it to myself, but now that it's live and is supposed to go out to several people it's not…
-
Copy/paste (or otherwise easily convert) contacts from a worksheet column to create a group
There needs to be a workflow that allows a user to select a contacts column and be able to copy/paste (or otherwise transfer) the values into group management. The current settings do not allow one to easily transfer or convert contacts in a worksheet column and into a group because of how the contacts field is formatted.…
-
Is there really no way to copy/paste a contact column to create a contact group?
Hi, I feel like I am eating crazy pills here, but is there really no way to copy contacts in a Smartsheet worksheet contact column into a Smartsheet contact group without jumping through insane workarounds? My contact column must allow for multiple contacts / cell. It uses the company directory, so it doesn't only have…