-
I want to count the number of times a contact appears in a column, how do I do that?
So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!
-
How do I keep contacts from being notified while I'm setting up a project?
Hi, I want to import info from an excel spreadsheet and set up the IT ticketing templates. But I am concerned that once I add peoples' email addresses into the contact column they will start to be notified. My question is, are people automatically notified just from adding their email address to the sheet? Or do I merely…
-
Contact List Column add to/don't overwrite
I am attempting to mass-edit my contact column for the purpose of Dynamic Views in a way that will add certain contacts based on the contents in other columns. Example: Column A is my contact column Column B is "State" Column C is "Department" Column D is "Advisor" If Column B= Illinois, then I want column A to include…
-
How do I enter Contact List details into a Form?
I want to be able to enter the Name and Email Address components into a Contact List column type field on a form. Is there any way to do this? Or even to create a formula in the Sheet that will calculate the Contact List value with display Name AND Email Address, not just one of the other. Otherwise, please Smartsheet, can…
-
Moblie Contacts App?
Does Smartsheet have any user interface options that could allow team members to access and/or update all contacts in a Smarthseet list with their phone? I am not finding anything out there, or maybe it is just a pipe dream. Ideally, it woudl function just like a contacts applications (Google, Outlook etc) but the source…
-
Mobile Contacts App tied to Smartsheet data
We recently had a request to find a mobile app that would funtion like other contacts apps (i.e. Google etc) but would be tied to a Smartsheet list. Ideally this could allow team members in the filed quickly access contact information at various sites and make updates on the fly. Our field teams would benefit from this,…
-
Why a contact is not saved after filling an update request?
When I receive an update request and I add a new validator, the contact can be selected and the update sended but when I check back in the grid the value is not stored. I discovered that when I delete the mail dropdown from the Validator column the value is stored in the cell. Here are the screenshots : For validator 2 I…
-
Contact list display/format as email address not name
Hi all, Although I found a thread from 2015 which partly answered my question, I would like to put the it again for updated context and clarity. I have many users in my smartsheet profile and use the contact column type in most of my sheets. I do a lot of list exporting and often need to provide email addresses for a…
-
Contact List Components: build a contact via formula
This is probably a pretty common request but it's frustrating me on a project right now so thought I'd bring it up. My idea is that Smartsheet make Contact List components accessible via logic and object calls. For instance if: Smartsheet.Objects.ContactList(Firstname, Lastname, Email) So if you have a columns containing…
-
Formula to auto assign based on request number series?
Is there a formula that could be used to assign staff automatically based on request number series? The sequential request number will be auto generated when the form is submitted. For example, if one location has three staff that get assigned requests in the order they are received, I would like to automate it so that:…
