-
Contact list field in form
How do I create a form with a drop down menu of a selection of contacts so that only the individual selected on the form will receive notification when a form has been submitted?
-
Multiple Contact Cell in a COUNTIFS statement to only extract one name
Hi all. I have been browsing the community for some time, but have been unable to find a solution to this issue. I have been trying to count a specific name from a multiple contact column, but calculations are not capturing the right number. I have tried two different approaches: {E2E Framework Solutions Funnel Range 21},…
-
Importing Contacts
Importing contacts using even the export headers/csv template isn't working. What seems to be the issue?
-
Link on view-only sheet to contact sheet owner
When I have a view-only sheet open, I would like to have a link on the screen for being able to contact the sheet's owner (such as to get the sheet permissions changed so that edits can be made). Currently I have to navigate back to the previous screen where I opened the sheet from, in order to see who the owner is.
-
How can a general user tell if a Contact listed on a sheet is a licensed user?
As a paid licensed user WITHOUT Admin privileges, is there a way to tell if a Contact listed on a sheet is a licensed user (free or paid) vs someone manually entered? Use case: Automations allow messages to be sent to "Limited" users in the same account or "Unrestricted" any email referenced. However, all contacts visually…
-
Bridge: Update a Contact Column Dropdown List?
Has anyone successfully used Bridge to update the dropdown values in a Contact List Column? I'm trying to modify a workflow that updates a Dropdown column - and it seems like it should work, but I keep getting this error (or something similar): I've tried formatting the source column as a Contact Column, a Text Column…
-
How can a general user tell if a Contact listed on a sheet is a licensed user?
As a paid licensed user WITHOUT Admin privileges, is there a way to tell if a Contact listed on a sheet is a licensed user (free or paid) vs someone manually entered? Use case: Automations allow messages to be sent to "Limited" users in the same account or "Unrestricted" any email referenced. However, all contacts visually…
-
Auto-populate emails on a "contact list" column
I have a Form created for internal employees where they can submit request tickets to my department. We all have an account with Smartsheet. One of our columns ("Requestor Name") is in the Form where they type in their names. The "Requestor Name" column is a Contac List column. My issue here is, how can I have Smartsheet…
-
Why do some names appear with a bubble in a Contact List column and other names do not
I have a sheet with a Contact List column type called Task Owner. I also have Summary fields set up that are Contact List types. The Task Owner fields are formulas to pull from one or more of the Summary fields. Example: Row 1 has a Task Name, Task Owner, Status, % Complete, Start Date, End Date, etc. The Task Owner field…
-
Need help with pulling contacts from another sheet
Hi. I have three different agencies that have a list of employee names and email addresses. When I do data entry into Smartsheets, I am trying to pull the list of the agencies email addresses into the form so I can send them an email. Here's the formula I have so far, but I'm getting an #incorrect arguement set.…
