-
Multiple email contacts in the IF statement
Hi, I have custom contact list column, which displays email contacts based on the conditions. Here's an example of that column: =IF(AND([Column1]@row = "Value1", OR([Column2]@row = "Value2", [Column2]@row = "Value3")), "email@email.com, email2@email.com, email3@email.com", IF(AND([Column1]@row = "Value5", OR([Column2]@row…
-
Allow multiple contacts per cell AND Restrict to list values only - Not Working
If I have a "contact" type column where I want to "allow multiple contacts" AND "restrict the list to the values" I've added to the column, then the list is not available. If I turn off the "allow multiple..." option, then it works as it should. Is there a restriction on contact type columns that disallows using both of…
-
How to Send Automated Email to Address Captured in a Form?
I'm setting up a help desk ticketing tracker. The help desk team takes calls from users and captures information in a Smartsheet form, which populates a sheet. The sheet autogenerates a ticket number. I want to automate an email to the caller's address, which was entered in the form. I was able to do this by setting up an…
-
V-LookUp to see if the same number ID is found in two separate sheets
Is there a formula that would check if the number ID in one sheet is also found in a separate sheet?
-
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…
