-
Dynamic View Contact List - Not showing all user names
@Genevieve P. My understanding is that a Contact field in Dynamic View will show a list of all users in the plan, and typing a portion of the name will show options. (Other community questions support this understanding.) Currently, it is not showing ALL users and typing a portion of the missing names does nothing. Why are…
-
Comment Automations
Greetings, Smartsheet Jedis! Is there a way of setting up an automation that alerts "specific people" as well as a "contact in a cell" whenever a comment is made on a sheet WITHOUT sending an alert to the person that submitted the comment? We currently have an automation in play that pings everyone whenever a comment is…
-
Auto Populate Contact List on Shared Smartsheet
Hello- I am looking for a solution to populate a couple hundred contacts into a Contact List for a shared Smartsheet without adding each contact to the sheet's Contact List manually. Here is the context: I have a shared Smartsheet that my team uses for tracking projects. Each project is assigned to a member of my team (all…
-
Backspace Functionality on Contact Object
Personally, I am infallible and have no need to remove a single character that I have ever written. However, I am assuming the rest of your users may misspell a name on occasion, or perhaps misplace a '.' in an email address on occasion. For those unfortunate individuals that fall victim to their own imperfection, the…
-
Contact Formula from Latest Comment Column
Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, if/when they are added in the latest comment. I currently can move (1) email but not multiple ones. I then put it in a helper…
-
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…