-
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…
-
Contact not populating correctly in automated workflow?
This is a cosmetic issue only, but it’s important to the person being singled out. I have a list of supervisors who get assigned when incidents are submitted. There’s an automated workflow that assigns the supervisor based on certain criteria. The assignment column has all the contacts with names and email addresses.…
-
Sort based on last name
I know this is a SIMPLE question, but I couldn't figure out how to do that. I have a column that consists of contacts, but I want to sort it based on the last name, not their first name. How would I do that?
-
Add Main Menu to WorkApps
It would be nice if the main menu in WorkApps included the same menu choices as core Smartsheet. For example, if a user who ONLY uses WorkApp needs to add or edit either a contact or their notification settings, I have to coach them to leave WorkApps and go to Smartsheet home. This is all you get in WorkApps, as opposed to:
-
Use Contact List (formatted column) as data source to lookup info
I have spent several hours searching for an answer to what I think should be something simple to do. I have a sheet with information related to a contact, (address, supervisor, ph numbers etc). All I want to do is reference the name in the Contact List (formatted column) to pull up other information related to that person.…
-
Only Unique Contacts Formula
I want to create a column formula that pulls all the contents of multiple contact cells @row and only print the contacts that are unique. I don't want to print the same contact in there twice if here happens to be duplicates. Additionally, this needs to be a "contacts only" field so we can reference this for alert…