-
Contact list display/format as email address not name
Hi all, Although I found a thread from 2015 which partly answered my question, I would like to put the it again for updated context and clarity. I have many users in my smartsheet profile and use the contact column type in most of my sheets. I do a lot of list exporting and often need to provide email addresses for a…
-
Contact List Components: build a contact via formula
This is probably a pretty common request but it's frustrating me on a project right now so thought I'd bring it up. My idea is that Smartsheet make Contact List components accessible via logic and object calls. For instance if: Smartsheet.Objects.ContactList(Firstname, Lastname, Email) So if you have a columns containing…
-
Formula to auto assign based on request number series?
Is there a formula that could be used to assign staff automatically based on request number series? The sequential request number will be auto generated when the form is submitted. For example, if one location has three staff that get assigned requests in the order they are received, I would like to automate it so that:…
-
Merged: Combining contact columns
This discussion has been merged.
-
Global Contact Lists for Business Plan Smartsheet Accounts?
My company just subscribed to Smartsheet. I'm the SysAdmin and I'm in the process of setting up our account settings. I wanted to set up a global contact list that every user on our business account can have access to? Can that be done? (it would make getting started with assigning tasks and sharing sheets so much easier…
-
Impact Assessment Workflow
Similar to the approval workflow, Allow admins to create a customized workflow that sends an impact assessment email to allow target users to indicate if they are impacted or not impacted on a project, request, task etc. The workflow should also allow the admins to customize the message body and also allow the user to…
-
Automate applying contact to cell after using form to submit data
I am using a form to gather request information from users outside of Smartsheet. I cannot ask all of the target form users to create a Smartsheet account, which makes what I would like to do probably more difficult. Is there a way to have the cell that I am currently having users put their name into when they submit the…
-
Add Contact details on bulk upload
I am trying to add contact details on the bulk upload but it allows me to add just name and email. I want to add Name, title, email, company name, office phone number, mobile phone number etc. how can i do that?
-
Remove cell contacts, already removed from contact list, and sharing list, and culumn properties.
Hello, I've noticed that contact columns save, or cache, the contacts that have been previously entered in that column. If I begin typing a name, it will produce a drop-down menu that includes all of the contacts which have previously been used in that column and which also begin with the letters I've entered. For example;…
-
Contact column selection - bulk upload
Hi everyone, Wanting to use the contact dropdown option in a column, is there a way to do a bulk upload to this so I don't have to select 100 contacts individually? Thank you!
