-
Ability to use "&" in "My Smartsheet Contacts"
We currently can't use an ampersand "&" as the contact name in "My Smartsheet Contacts". At my company, we typically use ampersands to identify groups in distribution email lists. Some examples are Marketing and Trading or Transmission and Distribution. which are shortened to M&T or T&D. My current workaround is to use a…
-
How to group by contact?
Hi everyone! I'm looking for the most efficient way to address this issue and I hope someone can help me. Currently, I have a form that permits multiple contact entries. This form is used to record the names of participants at an event. The form populates a sheet in such a way that all participant names for an event are…
-
Show Drop-Down Lists Properly in WorkApp
When you use WorkApps and show a report, with Editor rights on the item, the contact drop-down will not show correctly if it has multiple contacts and is restricted to those contacts. This stops the user from being able to change the field correctly in WorkApps. Please fix this so that WorkApp will be truly functional for…
-
email notification
I would like to set up my orientation registration smartsheet to send an automatic email to the person submitting the registration form confirming the date of the orientation. I do not want to share the sheet with everyone completing the form. I have a contact list column (this is who should receive the email) and an…
-
Counting individuals supported by specific customer removing repeats
Hi, I am trying to sum the number of individuals that are supported by a customer. There are several opportunities that support a single customer and within these opportunities the same individuals may be supporting the customer. How do I calculate the unique number of individuals who support a single customer. The…
-
Resource Management and Contact List
I have a project tracking sheet where the "Assigned To" field is a contact list. For the first row of the sheet, the Assigned To cell is calculated based on a Summary Sheet value (=[IT Contact]#). All the task level Assigned To values are then selected from the contact list from-down. This works fine until I turn on…
-
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…
