Contacts
Discussion List
-
Using CountIfs to track a column will multiple optionsIn Formulas and FunctionsHi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts…
-
-
Contact List - Extract First / Last Name?In Formulas and FunctionsIs it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there…
-
Cannot find new address for a contact from an automation or sheetIn Using SmartsheetWe did not want emails to go to external contacts, so "tricked the system" by creating contacts with the same internal email address: eg. Contact 1 : [email protected] Contact 2: [email protected] Recently, sm…
-
How to assign task to multiple contacts and track for each contacts completionIn Using SmartsheetHi, I'm building a sheet of tasks where some tasks will be assigned to multiple contacts and each assignee/contact will need to acknowledge that they've reviewed/completed the task. Multiple Contacts is enabled on the "assigned to&qu…
-
Filling out a FORM + requesting approval from a colleagueIn Using SmartsheetHi there! Right now, we have a PDF application filled out and emailed to managers to sign/approve. I would like to transfer the PDF application to a form. done. I am struggling with the "managers approval" part. I want applicant…
-
Notifications for Contact List Column OptionIn Formulas and FunctionsJust wondering if the notification for contact list within a column setting has been resolved and we can now get notifications when something has been assigned to us?Answered - Pending Review 46 views 12 comments 0 points Most recent by kdashnaw Formulas and Functions
-
contactsIn Using SmartsheetI have entered my smartsheet contacts manually including their email and name. Afterwards when using my contacts to send out update requests, only the email for the person is displayed for about 1/2 my list, the other 1/2 has both email an…
-
Using Match Function with Multiple Contact ColumnIn Formulas and FunctionsHello, I need to lookup a value in a table when a specific contact matches. I tried using match/index, however the column containing the contacts in the lookup table allows multiple contacts which I am unable to determine how to use match …Answered - Pending Review 210 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Using INDEX/COLLECT to return multiple valuesIn Formulas and FunctionsLooking for the proper way to return multiple values using INDEX/COLLECT. I'm assuming JOIN needs to be in there but can't get it to work! Both without and with JOIN, the formula still produces the first value only. This formula matches a …