-
Contact Collect/Join to Contacts will not filter (Current user)
I have contacts in a Collect/ Join in an [Assignee All Row] Field At its core: JOIN(COLLECT([RowRange1]@row:[RowRange2]@row, NOT(ISBLANK(@cell))), ", ") As far as I can tell ", " Comma-space is the delimiter for multiple e-mails in a multi-select column. FAILS: Filters on the sheets won't recognize (CURRENT USER) in the…
-
Restore the "Add New" Contact icon in the "share" screen
The Add New Contact icon has been removed from the share screen. Now a user has to take additional steps outside the flow of work to add/edit a new contact before being able to share the sheet. A user can add an email address to share, but then has to go into My Smartsheet Contacts to edit the information and add the…
-
Merged: Bring in Multiple Contacts to a Contact List Field using Index Match Functionality
This discussion has been merged.
-
Understanding Smartsheet User Profile Discrepancies: Name vs. Email Address in Workspaces and Sheets
Hi all! I've got an issue with Name and Email Address of a Smartsheet User not "linking" (for want of a better word). Please bear with me as I try to explain the problem! :) A Smartsheet user needs to be shared to a workspace. When I searched their name in order to share it with them, it shows me their name as they've…
-
Contacts within a Business License
Can anyone explain how contacts work on a shared/collaborative sheet within a Business license? For example, is the contact creator the only one who can make an update or delete the contact within that shared sheet? I'm trying to understand how this all works. Thanks, Karen
-
Question on merging single contact columns into one multi contact column
Hello, I have a contact column containing one person, and another contact column containing another person. I have another contact column that is set to take multiple contacts. What formula can I use to get both contacts into the one multi contact column? Thanks Steve.
-
Contact List not Populating
Hello, I have created a form with a couple of fields that have the Field Type set to contact list, but when testing the form nothing populates in the field, it's as if it was set to text / number. Is there a way to have it auto populate as a user begins to type a name? Thank you.
-
Problem with automation from a contact list
Hello, I'm having an issue importing email addresses from dataShuttle to a contact list, and using automation from this column. When I set up the automation triggers, it won't send to the emails in the contact list column, because it is saying it is a comment and there is an @email@org.com (just general example of what the…
-
Ability to delete Contact for All Users as an Admin
I want to remove a contact with for all users & all sheets in Smartsheet. It would be really nice to have a contact list in the Admin Center for the Admin to manage the Contacts in Smartsheet.
-
Are you able to pull emails from a Contact column?
I have a few sheets where I am needing to have the data Presented with the individuals name, then the email address in the column next to it. I have come across a few articles that have suggested having a helper 'Contacts Sheet' to reference w/ =INDEX({Contacts Sheet Email}, MATCH{Name@row, {Contacts Sheet Name}, 0)) for…
