-
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.…
-
Formula when a column has a checkbox
I cannot seem to find this answer: When a column has a checkbox, another column must have data in it or it will turn red Example. If someone is needed on site (it is checked) then a person(s) name must be in the box. They cannot leave it blank or it will be red. On Site Person <star> Contact List or cell is RED
-
Improve how logic functions work with contact columns
If a contact (e.g. one in my personal contact lists) has a text field name associated with it, it displays as that name. Then, if wanting to search for that contact in a contact column using the associated email address, it is not found. Please develop a function that returns as text the email address of a contact.…