-
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…
-
Bulk import contacts from Excel
I downloaded the CSV file from smartsheet with my contacts, I manage to add addiotionals and tried to upload it. It doesn't work. Why? Can I import somehow from excels file saved as CSV?
-
Contact List and Drop down List values can be referred using a reference from a different sheet
For Contact List and Drop-down list columns currently the values need to be added and updated individually in all columns and sheets eventhough the values are common for many columns and sheets. If we have a provision to have the values referred using a reference from a different sheet, then we can add or update the values…
-
Contacts Column Not allowing contact to be selected
I am a admin user and use a sheet to log communications. WE have a Contacts column where the staff member is suppose to select their name, as the person entering the data. However, when 1 particular user tries to enter their name, they receive the error below. The particular person's name has been added as a contact, but…
-
Request to Filter Deactivated Users from Contact List Columns
Currently when a column is setup to follow the "Contact List" functionality, the list of users it offers as selections includes users that have been marked as deactivated. Could Smartsheets instead exclude these users from the listing to ensure Project Managers don't accidentally assign task rows to users who are no longer…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
