-
Populating Multi_contact_List column through Alteryx
I have an Alteryx designer reading in tasks from multiple smartsheet schedules that have a responsibles column with multiple contacts. I want to rewrite those contacts into the one schedule I am writing to, but when the contact is read in, it is converted to TEXT_NUMBER and Alteryx won't let me write to the Multi Contact…
-
How to Use Contact List to Share a Sheet
Hello, I have a sheet with a contact list populated. I want to be able to share the sheet with the people in the contact list. When I copy the values of the contact list, and paste into the Share window, the contacts do not translate appropriately. Is this expected?
-
Split contacts to multiple columns.
In my sheet, I have multiple contacts in one cell. I would like to AUTOMATICALLY spread these contacts across multiple columns in the same row, so that each column has one single contact. The reason I want this is to send approval requests to each contact. (Currently, I can only send approval requests to all the approvers…
-
How to Display Contact Names in Dynamic View Export
I created a dynamic view that includes a Contact List column. When anyone exports the dynamic view, the contacts from the Contact List column appear as email addresses, not names. Is there any way to export the contact names, not the email addresses?
-
Notification trigger based on email, NOT display name spelling
This could probably have a better title. Here is the issue. We have an API that updates rows to sync with our accounting system. One of the fields is a contact field. It pulls an email from the accounting database. So if Bob Builder the contact, it will put in bbuilder@email.com. Even if Bob is in our enterprise contact…
-
Get a list value from another sheet
Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
-
API replacing name with email in contact column
Our API had been working fine for over 2 years. It adds/updates financial data rows, including the managers name. When it adds a new row, the manager comes in as an email. (It's in email format from the financial database, so that is what is posted to the cell). But I have a report ready to assist with cleaning that up and…
-
Auto Populate Contact List on Shared Smartsheet
Hello- I am looking for a solution to populate a couple hundred contacts into a Contact List for a shared Smartsheet without adding each contact to the sheet's Contact List manually. Here is the context: I have a shared Smartsheet that my team uses for tracking projects. Each project is assigned to a member of my team (all…
-
Problema importación de contactos
Intento importar contactos a través de la función importar contactos, selecciono el archivo (.cvs o .vcf), doy en aceptar, y luego no se cargan los contactos (hay un total de 924 contactos; entiendo que el límite es de 1000). Lo he intentado una infinidad de veces. Trabajo desde una iMac Sonoma 14.5
-
Collect List of Matching Emails from Selected Items in Dropdown
I have a column that is a dropdown of Names, multiple select enabled. I want to have a second column that another dropdown of the emails associated with those names. I have this: And would like to achieve this, in a separate sheet: The multi-name selection comes from a form, so this needs to be done with some formula,…