-
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…
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
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…
-
Sharing a Contact List
Good Morning. is there any chance to have a sheet in Smartsheet with a list of contacts and connect that list as Smartsheet contacts to share with all people within your Business account? (10 members with licence in my case) regards
-
Workflow Alert Mail
Good afternoon, I would like to ask if there is the possibility to create a workflow that sends email (Action: Alert someone/Request an update/Request an approval) using emails that are in a column inside the sheet but the type of the colum is a Text and not a Contact List. Thanks
-
Bridge: Update a Contact Column Dropdown List?
Has anyone successfully used Bridge to update the dropdown values in a Contact List Column? I'm trying to modify a workflow that updates a Dropdown column - and it seems like it should work, but I keep getting this error (or something similar): I've tried formatting the source column as a Contact Column, a Text Column…
-
Importing email addresses as Contacts
We have an Excel worksheet that contains email addresses and are using Data Shuttle into import them into a worksheet. The email addresses are going into a Contact column. In some of the cases the record will come in with the email address and other cases it converts to the person's name. Is there any way to force it to…
