-
What is the difference between "My Smartsheet Contacts" and unlicensed users on "User Management"?
Hi, I have been adding team members onto my projects via the "Contact List" in my "Assigned To" column and can see them in my "My Smartsheet contacts". However, I was then reading that I could add unlicensed "Users" via "User Management" and noticed that my Smartsheet contacts aren't there. Do I need to add them to both…
-
Control Center and Contact Columns
I am using control center to create projects. In the sheet that gets provisioned, I have my resources listed. I want to bring the "Lead" contact back into the Intake sheet, but it is coming back as just text and not an actual Contact. We use the Current User view for project updates, which won't work this way. Any ideas on…
-
Every time i want to make changes on my report it gives this pop up dont know what is happening
-
Smartsheet contact groups - outside org?
Are Smartsheet contact groups only used for assigning roles/permissions/access within an organization? Could I for example, create a contact group of emails that are outside my organization so that I could easily share a dynamic view with all of them? The underlying sheet would have a contact column and I would restrict…
-
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…
-
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…
