-
How can I retrieve deleted approval request email?
hi, I have a work approval request flow that being used to our department for document approval process. We have one manager who accidentally deleted the approval request email and we don't know how to retrieved it since it was gone in to the email deleted folder. Is there a way to retrieve an approval request email? how?…
-
How do you create a contact list based on 2 seperate sheets using a Vlookup.
Hello, Looking for some assistance with an issue we are having populating contact lists based on 2 separate sheets using a vlookup. To summarize the attachment, we have a sheet with a list of account owners and their email addresses (Client Services Listing) that is feeding into another sheet (CSLS Teams by Account) which…
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
Can my contacts be updated by my company AD (eg. contacts in our Outlook Address book)?
I want My Contacts to be up to date with my company address book. Is this possible?
-
Counting people with the same email domain in a multiselect assigned to cell
Hi there I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual. I want to count how many of the contacts in the cell belong to the same company. I.e. have the same email domain. In…
-
Add contacts to a cell
Any ideas or workarounds to add several contacts on a sheet to a cell in another sheet? I need to send an alert to the project team. I've shared the sheet with the project team but also with alot of other people who don't need the alert.
-
Form Issue: Auto-Complete Contact Column
Hi All, I think this feature should be a part of the Smartsheet web client, however, it is not. BUT it is a part of the mobile app. When I go to type someone's name into a contact column field USING A FORM, it won't auto complete and show you a drop down of available contacts. When you use the mobile version and are…
-
What is the effective approach to Group Management and Contacts
i would like to have a contact with name. I need Groups so have to add contacts via Group Management else it won't allow me to add a contact from "My Smartsheet Contacts" Within Groups, I can either paste all emails or add one by one. The former will not allow names to be added, the latter is manual and painstaking if I…
-
Contact Lookup/Reference from Another Sheet
Hello, I am trying to work out a formula that will raise a flag if any contacts in a column (Attendees) are listed on a separate sheet (VIP). The attendees column could have multiple names listed, the VIP column will only have one name per row. I am running into errors with the formulas that I have been trying, and not…
-
Using VLOOKUP for Approval Requests Across Sheets
GOAL: 1) Have a secure and error-free VLOOKUP on Sheet B and 2) Run a multi-level approval request automation on Sheet B. DETAILS: I have 2 sheets. Sheet A tracks contracts. It has columns for individuals (contacts) who are designated approvers for changes on contracts. Sheet B tracks providers named on the contracts to…
