-
Smartsheet Salesforce Integration: "Value is not supported for this column Type."
I have created Workflow for bi-directional sync in the Smartsheet Salesforce Connector between Salesforce and Smartsheet. In Salesforce, I have a Lookup(User) field named "Assigned To" and in Smartsheet, I have a corresponding "Assignee" column with the Multi-Select Contact List data type. When I update the "Assignee"…
-
How to Edit Email of a Manually Added Contact in "Assigned To" Contact List Column?
Hi All, I’m a System Admin in our Smartsheet environment. We have a sheet with an "Assigned To" column, which is set up as a Contact List column. All contacts listed in this column are Smartsheet users from our organization except one — this particular contact seems to have been manually added by another user (not from our…
-
My contacts do not display in Contact Picker
I imported 140 contacts successfully. They are listed in the "My Contacts" view. However, when I try to pick a user in a column, only my own user contact appears under the "My Smartsheet Contacts" filter. If I add another contact manually in that picker it does not appear in the "My Smartsheet Contacts" view. Its as if…
-
Contact field list management (data shuttle or groups)
Managing contact field lists for numerous sheets is time-consuming and subject to error. The ability to manage this by using Data Shuttle to update the contact field options OR being able to select a "group" for contact field options allows this field to dynamically update from a central location.
-
how can I add on the roll up table my contact list of mangers so that the formula work
i have tried adding the email - the name but it doesn't work ! this is the formula I have used and referenced the assigned to and status column
-
If Then Help
If a cell in Column A (titled Job) equals Marketing (from drop down in Column A), then adjacent cell in Column B (titled Responsible) equals Susan (name from contact list). I want someone to choose from a drop down in Column A, then based on their choice a particular person receives an email. Column A is set for multiple…
-
Contact List Dropdown
When using a Sheet, we can easily access our company's directory for a contact list. However, this functionality seems to be missing when using the Form, requiring me to manually add contacts. It would be fantastic if the Form's contact cell could work the same way as the Sheet's contact cell.
-
Copying Emails from Outlook into Contact Cells in Smartsheets
I'm sure there is a simpler way to do this, but I'm not sure how. I want to copy and paste emails into a contact cell in my Smartsheets. When I copy them from out look it retains the format like this and doesn't recognize that person as a Smartsheet contact. Obviously, I can type in the names and their contacts will come…
-
Copying and Pasting Contacts From Outlook
Smartsheet should implement the ability to copy and paste contacts directly from the "To" or "Required" fields within Outlook. If the system already has the contact listed it can match them to that existing entry. However, if the contact is new it should automatically use the information copied to create an entry. When…
-
Adding contacts on an organization level
Is there a way to add contacts on an organization level so that the contact list will be the same for all users in an organization? If it isn't possible, is there a way to quickly add this on a workspace level? (Without having each user add it on their 'My Smartsheet Contacts' manually each time)