-
How many rows a contact is entered in a sheet?
Hello! I am trying to count how many rows a contact is entered in a sheet. Do I create a summary field? I am using this formula for my text/number summary fields to count each status (for a report that I am using in a dashboard): =COUNTIF(Status:Status, "Purchased"). Status is a text field. What summary field type and…
-
Client name incorrect in Contact List background and will not change
I inherited the Smartsheets/workbooks a couple of years ago, and I recently noticed (on an update workflow request I just created) that a client's name is incorrect. I can not change it. Any ideas where this name is stuck or how I correct it? When I tried to figure out why this happened, I noticed that the name appears…
-
IF statement to Output Column Contact List Name
Hello! I feel like this is a fairly easy formula, but having issues populating the ACTUAL contact name vs. the TEXT value using an IF statement. Goal: In this example, when I change the status to phase 1, I would like the Current Assignee cell to populate the contact name. However it is populating the value and not the…
-
Pre-Populate a large contacts drop down
Under Contacts List type - where the 'Values (Optional)" is, I have about 574 e-mail addresses to pop in there. I want to restrict the list to a contacts drop down as it will run some automation and also drive the access permissions in Dynamic view. Seems I can only pick a record at a time though, I can't figure the string…
-
How do you represent your team contacts in a dashboard?
Hi There, I would like to add a widgit that shows team members, titles, and contact info but I am unsure how to do this. Is there a way to include contacts in a dashboard pull from Smartsheets?
-
Adding names to Contact List Dropdowns
Can I add hundreds of names to a drop down contact list relatively quickly? I have to add ~1000 contacts to my drop down and the thought of entering them one by one is daunting. Is there a faster way?
-
Contacts in a Form
Hi I'm working on a submission form but, I'm struggling with the contact columns. The use case is that a file review will be done on any one of over a 1,000 lawyers the compliance officer completing the file review needs to enter the lawyer and their supervisors name in the form so, that reminders can be sent to complete…
-
How can I set a contact list column to display only the email and not the contact's name?
I often have to use lookup formulas between sheets where one sheet is a system export of information loaded into Smartsheet. The system obviously generates an email displaying as text. In a prior support call I was told to convert the column to a contact list and that has served me well. I've created a Message Tool for…
-
Contact List formatting from formula only showing email address
I've got a formula that pulls contacts from another reference sheet into a Contact List column, but it also checks an adjacent column for a value to transpose a would-be contact: =IFERROR(IF(Resource@row = "Eric R.", "erussell@email.com", INDEX(COLLECT({IT Requisition Tasks Resource}, {IT Requisition Tasks Task Name},…