-
Can Card View utilize Multiple Contacts in Assigned to column?
I'd like to use the Card View Assigned To feature to provide action items to a team. Line items may have multiple responsible parties. Does this prevent sorting cards by Assigned to (i.e. only a single contact may be added per line item?)
-
How to have automation populate specific contact within column based on state selected in row?
Scenario: You need alerts and approval requests to go to "contacts in a cell" based on department and state. Is there any way to accomplish this aside from creating a separate contact column for every single state which then has to also be programmed into the automations? (i.e. Request 1 affects all departments for GA, NC,…
-
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…
-
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.…
