-
Can you alert/send an email to contacts in a cell that have been entered via a form?
I have my alert settings to Unrestricted, but even so, it seems those who fill out our form cannot be notified since they are not users of SmartSheet. I am looking for a solution other than the "Send me a copy of my responses" option. TIA! 😁
-
How do you make a name input on a form become a contact that is already a contact in Smartsheet?
I posted this on an old thread, but thought it might be easier to find as a new entry. I am trying to have a contact show up in cells based on input on a form. User fills out form with account manager name. For example, Rachel Alexander. Rachel is in my contacts. However, when the data from the form populates the sheet it…
-
Emails are not reliably going to my users
I have a sheet that connects to several dynamic views. One one of the dynamic views, the (unlicensed) user enters their network ID. The sheet then grabs information from another sheet to pull in email addresses for the user and their manager. There is automation that is then supposed to send email summaries of the…
-
Linking contacts from sheet A to sheet B
I am trying to connect contacts from Sheet A to a workflow automated message from a form in Sheet B. Is something like this possible? Sheet A is a database of people listing names, skills, locations, emails, etc. Sheet B is fed by a form, I would like new rows to trigger a workflow to send an automatic message to a subset…
-
Create multi-contact cell from a row array of individual contacts
I have a sheet as: Header: SME1; SME2; SME3; All SMEs Row 1: Bill Ross; Suzie Collins; Anne Doe; =join([SME1:SME3]@row) Each of the SME columns is a contact. I want to fill my 'All SMEs' column with a formula which makes a multi-contact with all of the contacts joined together for easier filtering. I've tried to write the…
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Autofill contact details
Hello all, I'm trying to create a formula to "Autofill" contact (Name, phone number & Email), What is the smartest, fastest way to create a formula for over 500 contacts? Thank you
-
Contact list across users at Admin level
Hi! I'm looking to load a list of individuals that would show up in a drop down list as a collaborator. These individuals would not be smartsheet users, but we would want them to be able to receive automations and alerts. Everything I find is for "users". Can you upload a contact list (with individuals that are not users)…
-
Populate/Select a Contact (from a list) depending on the value selected in another cell
I have a problem I can't quite solve and I'm not sure if it's just not possible: I have a 'Responsible' column that is a list of Contacts. I have another column called 'Site' that is a drop down list. Depending on what 'Site' is selected I'd like the corresponding 'Responsible' to be populated. Example: If Site 'NYC' is…
-
Workflow Update to Email Generated PDF
Hello team, I would like to build a sheet with automation to update and generate my PDF. After it generates from the form, the generated PDF should automatically be sent to the email contact drop down listed on the form. When the user inserts an email & pushes submit that form/pdf emails out to the email listed by user. As…