-
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…
-
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:
-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
