-
Contact List suggestions not showing on Dynamic View
I have a number of contacts added to our sheet, however, when other people in my team access the sheet via dynamic view they cannot see the contact list suggestions on the dropdown.
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Extracting Email Address From Contact Column
Hello, I have a contact column from which I'm trying to extract the email address. I've seen instances where a helper column is created that is set equal to the primary contact column and the helper column is changed from contact to text. That approach won't work for us because the contact column will have new inputs and…
-
Trying to collect data from a sheet where a person assigned is one of multiple contacts
Hi, I'm trying to revise a formula and am a bit stuck on how to do it. I would like to pull resource utilization information from my Project Plan into a Team sheet (and no, we don't have the Resource Management module or Control Center at my organization). Here is an example of the current formulas I'm working with:…
-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
-
Best practices for approval process - contact list or no contact list?
Scenario: we are using smartsheets as a single-source tool for job/position requests. Each request submitted creates a row and all information pertaining to that request is held within that row. We need to get approvals from Department Heads for each request submitted. However, we don't necessarily want to create a contact…
-
Dynamic View: Contact List Must be Restricted
Hi All, Is there a reason why the Contact List on the Dynamic View must be restricted from putting names on the dropdown? If it is not restricted, it will only show the Users within your plan. This is counter-intuitive because one of the main purposes of using dynamic view is to share editing permission for external…
-
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!
-
Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
-
Filling a Contact List from another sheet
Hello everyone, I have a sheet that has a list of all of the managers and supervisors in my organization and I keep it updated monthly. I have another sheet that has a Contact List field and I am trying to see if there is a way to connect the Contact List field to the Sup/Mgr sheet, so that it automatically updates when I…
