-
Please enable us to select multiple contacts when sharing (was avialable a year or so ago)
About a year or so ago, if you wanted to share anything in Smartsheet, you had the ability to bring up your entire contact list or type a keyword, you would then be able to select multiple contacts to share with the same customize message. Please bring that back. It is a much-missed function. Thank you!
-
Text in 'Contact List' variable
Hi all, I would like to bring forward a new idea. I have an 'assigned to' column with a 'contact list' variable. In the settings, I allow to also just enter text of names (for example for people not having a SS account) - as in the settings I did not select 'Restrict to list values only' (see screenshot below). It is all…
-
Text in 'Contact List' variable
Hi all, I would like to ask a stupid question. I have an 'assigned to' column with a 'contact list' variable. In the settings, I allow to also just enter text of names (for example for people not having a SS account) - as in the settings I did not select 'Restrict to list values only' (see screenshot below). It is all…
-
Getting the email address for a contact
Hi, I have a contact column and I need the email address from the contact. Is there a way to derive the email address from a Contact column into another column as an email address?
-
Alert Someone Automation
Hi all, I am attempting to set up an automated workflow for account collections. A single sheet will include cash collections for multiple clients. I have RYG triggers set up to run alerts on the 5th day once and then recurring daily on the 10th, no problem. My issue lies with the contacts. I have separate contacts listed…
-
Smartsheet automation restriction
I have created a sheet with different contact names and assigned specific and different automation to those individual contact names. But now on trigger for the automation, the notification is getting shared with all, which I don't want. Also in automation I have set the parameters like it should be notified only to the…
-
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?
