-
How to add contacts in bulk in Contact List - Restrict list to values only
Hi there, I'm working on building a request form for my team. I'd like to add all 85 members as contacts in the Contact List field, and Restrict to list values only. How can do this in bulk without having to manually type out/select each name in the Add contacts lookup? Help?!
-
How to convert multiple TEXT names or emails into multiple contacts using Bridge
There currently isn't a way to use a formula to bring together and output multiple contacts into one cell, the values will appear as Text values. (SS Enhancement request submitted). However, I was told there is a way to use Bridge to convert the combined multiple contacts from TEXT to contacts. Please show me the solution.…
-
Pivot App is not recognizing the Contact Columns
We had a lot of pivot tables built from Contact columns but all were showing blank now, when I test manually by creating a new pivots I see contacts columns were not recognizing in the pivot apps, all summaries were grouped under the Blank row. Here is my example eCOA Implementation PM is a contact column and have lot of…
-
Contact Field in Index Match Returning Strange Values
I have a project plan template that is created through the control center. The owner of certain tasks is dependent on what department the project is in. I have a background sheet that is a task owner crosswalk, and then on the project plan it will run an index / match to pull the correct owner. This has been working fine…
-
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':…
-
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…
-
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…