-
Enterprise Plans - Active Directory Integration for Contact Columns
I would like the ability to have the option to add all Smartsheet users in the same plan as dropdown options in a contact column. For enterprise plans using AD, this would create an active staff dropdown column. This would solve many issues and workarounds for HR, IT, and PM functions.
-
SF Connector and Smartsheet contacts
Hello, I'm playing around with several different SF connector workflows. One of the workflows I'm testing out is for our Project object. Our SF project object has fields listed for Project Manager, Project Engineer, Delivery Manager, etc. The team members that will populate in those SF fields also have access to…
-
Workflow - Sending email with "Send to contacts in a cell" isn't working
Hi! I'm trying to set up a workflow which sends notifications only to a contact in a cell which is part of a contact column. Although permissions are set to "Unrestricted" the workflow isn't working! A test environment with my name in the contact cell isn't working too. Any idea what to check or change? Thx in advance!
-
Contains Function cannot find value for contact list data type
Hello, I'm trying to use the COUNTIF and CONTAINS functions to count the values in the percent column based off the values in the Names column with the contact list column type. Here is the formula I have so far: =SUMIF(Names1:Names3, CONTAINS("Anthony", @cell), Percent1:Percent3) And here is the data: When I change the…
-
Multiple Approvers from ever-changing approval list
My update request needs to go to all employees (approx 100). The list is always changing and it is not feasible to scroll through to double check each employee is still working here or verify new hires. It's also not feasible to click each employee for every new row in my spreadsheet. I tried forwarding an update request…
-
Contact list column only with photo
Hello, Is there a way to display only the photo or photo + first name in a contact list column? The full name makes it lengthy.
-
Contact list field in form
How do I create a form with a drop down menu of a selection of contacts so that only the individual selected on the form will receive notification when a form has been submitted?
-
Using INDEX/COLLECT to return multiple values
Looking for the proper way to return multiple values using INDEX/COLLECT. I'm assuming JOIN needs to be in there but can't get it to work! Both without and with JOIN, the formula still produces the first value only. This formula matches a project number from one sheet to another, and is supposed to return ALL of the…
-
Contact list of users
Hi, We are currently creating a sheet/form for staff to submit a trip plan. This requires noting each staff member travelling in the vehicle so a new column for each staff, which then pulls through their emergency contact information. At the moment, for each column, I am having to add the staff names to the contact list so…
-
Contact list of users
Hi, We are currently creating a sheet/form for staff to submit a trip plan. This requires noting each staff member travelling in the vehicle so a new column for each staff, which then pulls through their emergency contact information. At the moment, for each column, I am having to add the staff names to the contact list so…
