-
Inconsistent results when using contact list columns
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…
-
Contracts, Purchase Orders, or Change Order Management
Is anyone using Smartsheet to handle contracts, purchase orders, or change orders? I'd love to see how you manage them with Smartsheet.
-
Change contact on update request emails
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?
-
Using IF and OR to Assign a Contact
I am currently using the following: =IF(Line@row = "Apples", {Contact 1}), IF(Line@row = "Oranges", {Contact 2}), IF(Line@row = "Pineapples", {Contact 3}), IF(OR(Line@row = "Red Grapes", Line@row = "Blue Grapes", Line@row = "Purple Grapes", Line@row = "Green Grapes"), {Contact 4}), IF(OR(Line@row = "Pears", Line@row =…
-
Restrict a Contact list to a single sheet
My use case is with collaboration with external companies. Currently, Columns listed for Contact List are auto-resolving and showing internal contacts and other external contacts. I'd like to either disable auto-resolve or create a restricted list of contacts only available to those who can view the sheet. Is this possible…
-
Editor Permissions
Hi, We have sensitive data and its important for us the shared Editor to be able to edit cells information but not to be permitted to delete rows and columns . Is there a way to configure sheet sharing permissions for editors and public users and and not to allow them delete the rows and columns ? Thank you
-
Limit Proof Request List
Is there a way to reduce the 1700 smartsheet users under my "Request Feedback" list under proof reviews? I'd like to make the list limited to the 9 people authorized to make revisions so others aren't selected/tagged by mistake. Thanks, -Luke
-
Validate an email address in a contact list
Hello, We have a situation where we have two employees with the same name, "Test User", and they have the following email addresses: test.user@smartsheet.com test.user2@smartsheet.com (Please notice the "2" in this email.) We use a form to populate our sheet and the form user is required to type(paste) the email address…
-
Current user + formula in Contact List?
I'm trying to auto-assign an owner to a task based on the task type: The Owner column is a Contact List Column and the email addresses specified in the formula are associated with current user accounts (one being myself). But when I use a Current User filter, nothing shows! I can only assume that using a formula to fill a…
-
Calculation of the number of actions per contact for a multi-contact cell
Hello, I am new to using Smartsheet and I want to extract the number of cells that refer to a contact. This may seem simple, but Smartsheet only takes into account the first contact mentioned in a cell, if it has several. Example for the year 2020: How many times was the contact "e-mail address" mentioned? -->…
