-
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,…
-
How can I sync my Smartsheet contacts to a drop down in a form instead of manually entering each one
I created a form in SS which allows users to select employee names from a drop down menu. However, I have over 1k employees. Right now I would have to manually enter each name to the drop down. How can I sync my contact list to the drop down in the form?
-
Copy row automation is not copying all data (assigned people in contact list row)
We have a 'copy rows to another sheet' automation that is working correctly except for one column, the "assigned to"/contacts column has stopped copying the data. It was working well until last week. No changes to the automation took place. I removed and re-added the automation and confirmed no automations in the…
-
Is there a way to convert a large number of contact cells at once?
I have over 5000 rows in a sheet that has been exported from ServiceNow. Every row has a contact cell that is filled out with a raw name, no company email. Is there a way of converting every cell into the respective company email for that person at once? The manual method, typing their name and selecting the pop up, will…
-
Assigning Multiple Resources
I've seen posts going back 3 years that address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at least three different team members assigned to it at once. Without the ability to…
-
Contact Lists
I created a column for names and entered the column type as a contact list, which works great and pulls from our company directory of names, in turn, I can create a workflow to alert that employee as the email is connected to the name in this format. BUT, when someone submits information via the form connected to the sheet…
-
Ability to Tag Smartsheet Group in Contact Field
Currently there is only the ability to add a column and add contacts (single or multiple) to a field. This causes issues when attempting to control who can view something within a dynamic view. It would be beneficial if there was the ability to add a 'group' to a contact field so that we could 'restrict view by current…
