Can I add hundreds of names to a drop down contact list relatively quickly? I have to add ~1000 contacts to my drop down and the thought of entering them one by one is daunting. Is there a faster way?
Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
Hi I'm working on a submission form but, I'm struggling with the contact columns. The use case is that a file review will be done on any one of over a 1,000 lawyers the compliance officer completing the file review needs to enter the lawyer and their supervisors name in the form so, that reminders can be sent to complete…
I often have to use lookup formulas between sheets where one sheet is a system export of information loaded into Smartsheet. The system obviously generates an email displaying as text. In a prior support call I was told to convert the column to a contact list and that has served me well. I've created a Message Tool for…
I've got a formula that pulls contacts from another reference sheet into a Contact List column, but it also checks an adjacent column for a value to transpose a would-be contact: =IFERROR(IF(Resource@row = "Eric R.", "erussell@email.com", INDEX(COLLECT({IT Requisition Tasks Resource}, {IT Requisition Tasks Task Name},…
I am attempting to use the API to perform CRUD actions on a sheet. Several of the columns have Contact/Multi-Contact datatypes. I have discerned through practice that when I create or update a row, that the API expects the email of the contact to be provided in the request. Question number 1: Is that actually the case? I…
Is anyone using Smartsheet to handle contracts, purchase orders, or change orders? I'd love to see how you manage them with Smartsheet.
3年前,我看到帖子address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at least three different team members assigned to it at once. Without the ability to…
I have built update requests through the automation tool, but now to deploy the solution, I want to have the automated emails come from another user. Is there a way to change the contact?
